How to collect the Performance Statistics of the JOB

sreedharmsc · Post by **sreedharmsc** » Wed Aug 13, 2008 1:58 am

How to to collect the Performance Statistics of the JOB after each Execution/run

dspxlearn · Post by **dspxlearn** » Wed Aug 13, 2008 2:06 am

sreedharmsc,

You can call the DSJOB commands in your script which actullay runs your datastage job. Take the first and last evenId of the job and then add 1 to get all your job parameters by using the 'lognewest' option with DSJOB.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 13, 2008 3:04 am

Buy MetaStage and have them collected automatically. (Note that MetaStage ceases to exist with effect from version 8.0).

Download ETLstats from Kim Duke's website which is a set of tools that will gather these statistics and put them wherever you like.

Don't re-invent the wheel!