Getting Job Elapsed time for all datastage jobs

singhald · Post by **singhald** » Mon Feb 23, 2009 1:45 pm

Hi All,

I need your help to get the job elapsed time for al datastage job in a project.

i am able to get the elapsed time for a job by using dsjob -report projectname jobname command. but it can give only for one job, please write me if it is possible to get the elapsed time for all datastage jobs by using any command, or also i want to know do we have any option to get all datastage jobs present in a project by any command.

Thanks

chulett · Post by **chulett** » Mon Feb 23, 2009 2:15 pm

dsjob -ljobs

Then use the output from that to drive a loop where you do like you are doing now, one at a time.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 23, 2009 2:51 pm

Download ETLstats from Kim Duke's website - which will do it all for you.