It's all about the answers!

Ask a question

Insight: Looking for the job that updates ETL_INFO table

Timur Markunin (6495161145) | asked Feb 06 '13, 5:43 a.m.

I'm creating my own ETL job. I need to implement incremental behaviour so I want to utilize $MODIFIED_SINCE variable. 
My understanding is that I need to somehow insert info about last successful run of my job into ETL_INFO table and then initialize $MODIFIED_SINCE using GetNFLastETLSuccessDateTime function.

Am I right? How could I insert data into ETL_INFO?

-thanks in advance

Accepted answer

permanent link
Junli Wang (5512) | answered Feb 06 '13, 6:08 a.m.
just use a procedure node containing the user defined function: SetNFETLStatusDateTime, at the end of your job.
this function will insert data into ETL_INFO table.
you may refer to the existing jobs doing this, eg Jobs->CQJobs->ALM

Timur Markunin selected this answer as the correct answer

Timur Markunin commented Feb 06 '13, 7:39 a.m.

Thanks Junli! Maybe you could also comment on $RESULT variable usage?

I use following procedure:

In execution log I have:
[PROGRESS   - 12:29:55] Build Node 2 'Sber_Timesheet'; succeeded
[VARIABLE   - 12:29:55] RESULT = TRUE
[PROGRESS   - 12:29:55] Procedure Node 3 'SetFinishedTime'; reported the following:

DM-EXP-0003 An expression validation error occurred at position 3
Unknown variable '$RESULT2'.

I don't understand how I could use $RESULT variable....

Junli Wang commented Feb 06 '13, 7:59 a.m.

right click on the build in the job, open the Properties window,  the second tab 'Details', there is a text box you can define the result variable, eg. you input 'Result1', in the later procedure node, Result1 will be referred as the result of this build.

Your answer

Register or to post your answer.