Getting Job Run statistics

[DSRajesh]

Dear Team,

I need to build a job such that it has to get the job run in formation like job name,job status,start time,end time,row count,created by,updated by fields etc fields.

how can store these fields values in a file/table if we use job control routine?

is there any functions in parallel trnsformer to get the values for end time,created by,updated by fields?

please suggest me on the above process how to approach?

Thanks

[ray.wurlod]

Download ETLstats (free) from Kim Duke's website - you will find that this particular wheel has already been invented.

[kduke]

There are lots of posts on how to install it. Do a search.

[DSRajesh]

Hi Ray

I want to capture them from dsodb of operations console db introduced from 8.7 onwards.

can you please tell me how can i query the tables from dsodb to load that a scheduled day every job run.