Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) ;
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();
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();
Thanks You...Trace did the trick