Job stat reporting...

acme01 · Post by **acme01** » 05 Oct 2006 4:12

Hi...

...I used to have a few scripts over the years for pulling data about job stats from control-m; but these were based around sybase d/b's, and may be of no use with oracle d/b's.

I have created a shout table (EXECTIME) that receives messages from any job that runs for more than 75% of it's average runtime; which is then written to a file.

However, what I need to do now, is to pull together a report that will have the following information, for the jobs that 'shout' to EXECTIME.

Headings should be.....
JOBNAME
START DATE
START TIME
END DATE
END TIME
ALERT INCREASE (or shout %)
ALERT TIME
TOTAL RUNTIME
AVERAGE RUNTIME
ACTUAL INCREASE

Does anyone know of the best way of doing this, or have a script that can pull this information to a single file.

Thanks everyone for any assistance.

Post by **fyot** » 06 Oct 2006 9:08

Hi,

Normally if you use the same version, database diagram is exactly the same. Nevertheless, if you change from Control-M 2.2.4 to 6.x you will have some issues. Fields and Tables changed.

You could find Database Posters on that site in download part.

acme01 · Post by **acme01** » 06 Oct 2006 12:50

Thanks for that. We are on a mix of 6.1 and 6.2, but headed for 6.3.

Also, I have been after a copy of the d/b model for a while....cool...

I guess I'll need to to start, more or less, from scratch with the new singing and dancing field and table names.

Cheers.....Steve.