Execution Time

chulett · Post by **chulett** » Mon Mar 05, 2012 10:50 am

Command line via dsjob -jobinfo or from a routine using DSGetJobInfo() can get you elapsed time and then you can compare the results.

joycerecacho · Post by **joycerecacho** » Mon Mar 05, 2012 12:08 pm

Tks friend.

Can I do it inside the transformer, can I use this function inside the transformer?

I thought about read the universe table DS_JOBS through The stage Universe and then use this function inside the transformer, informing the jobname as the parameter.

Tksss!!

Best regards,

ray.wurlod · Post by **ray.wurlod** » Mon Mar 05, 2012 3:24 pm

Create a routine to get the start and end timestamps from a job. Call this routine from a Transformer stage. Have your job process job names from DS_JOBS (filtering out "category" entries, for example NAME MATCHES "1A0X").

chulett · Post by **chulett** » Tue Mar 06, 2012 1:44 pm

One thing - make sure you don't try to attach to the job that is running this routine, that will cause a hang.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 06, 2012 3:08 pm

It does run, even though slowly. DSGetJob() actually does a lot of work.
Attach and Detach are also not without their overheads.

To implement Craig's suggestion, simply test that the selected job name is not the same as that of the calling job.