Page 1 of 1

Getting Job Elapsed time for all datastage jobs

Posted: Mon Feb 23, 2009 1:45 pm
by singhald
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

Posted: Mon Feb 23, 2009 2:15 pm
by chulett
dsjob -ljobs

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

Posted: Mon Feb 23, 2009 2:51 pm
by ray.wurlod
Download ETLstats from Kim Duke's website - which will do it all for you.