Log run times in DataLoad Editor

[nvrphanikumar]

Hi,

Currently ,My process runs for about 2 hours and I would like to know which steps is taking longer to run.

tried an approach below ,where I declare a variable and then Output that variable as soon as the step is completed.But couldn't get it to work.

LET StartOfScript = Now();

Table_A:

LOAD

*

FROM [lib://QVDS/TABLE_A.qvd](qvd) ;

$(StartOfScript) ;

[maxgro · Accepted solution]

LET Start = Now();

//SLEEP 1000;

Table_A: LOAD * ...... ;

LET Elapsed = interval(Now() - '$(Start)');

Trace $(Elapsed);

LET Start = Now();

//SLEEP 3000;

Table_B: LOAD * ...... ;

LET Elapsed = interval(Now() - '$(Start)');

Trace $(Elapsed);

LET Start = Now();

[nvrphanikumar]

Thanks You...Trace did the trick