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.