It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×11,924
×1,235

question asked: Feb 06 '13, 5:43 a.m.
question was seen: 3,941 times
last updated: Feb 06 '13, 7:59 a.m.

Related questions

FAQ - How this Forum works

Insight: Looking for the job that updates ETL_INFO table

0
1
Timur Markunin (649●5●165●145) | asked Feb 06 '13, 5:43 a.m.
 Hello,

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

2
permanent link
Junli Wang (551●2) | answered Feb 06 '13, 6:08 a.m.
JAZZ DEVELOPER
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
Comments
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:
IF($RESULT2=TRUE) then
SetNFETLStatusDateTime(...

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.
JAZZ DEVELOPER

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.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.