We have a requirement to generate report oj job-run stats with start time/end-time. This is required to asses and verify time taken by a job for completion.
In my enviornment (EM) we have standard 2 days archived network enabled so Reporting Facility -> Active Jobs does not provide these details beyond 2 days.
I have tried using ctmruninf/ctmstats utilities, however ctmruninf utility truncates job names only to ten characters and the output does not provide right information.
So if there any other way to extract this information directly from the database, may be using any SQL Statement directly on CMR_RUNINF table ?
Regards,
Vijay Dogra
Job Run Statistics Data...
Suggested post was very helpful, after some tweaks to given SQL i was able to fetch the required data.
The issue with ctmruninf seems to be with the column width set for the output as i was able to get the desired data with your script.
Many thanks for your help. i guess BMC should do something about ctmruninf and ctmstats utilities.
The issue with ctmruninf seems to be with the column width set for the output as i was able to get the desired data with your script.
Many thanks for your help. i guess BMC should do something about ctmruninf and ctmstats utilities.
Th complete the picture of options here:
Have a look at the statistical reporting of VISUALjob for Control-M:
http://www.apsware.com/control-m-soluti ... control-m/
Those reports can also be generated in batch, producing a ready to use excel sheet and automatically emailed to a recipient list.
Have a look at the statistical reporting of VISUALjob for Control-M:
http://www.apsware.com/control-m-soluti ... control-m/
Those reports can also be generated in batch, producing a ready to use excel sheet and automatically emailed to a recipient list.