Hi to all.
I have requested a report of the executions of the jobs of yesterday.
But, they want to contain all the executions of the cyclic jobs, and status startrun and endrun.
As I can get that information.
Had made a query but I only received the job and the times had been executed. But I want to say that all executions.
select job_name, ORDER_ID, RERUN_COUNTER, STATUS, ODATE from A110627001_AJOB where ODATE='110627';
Thanks to all.
Job Statistics
SQL SCRIPTS
What version are you on. If you are on 6.4.01 or later, statistics information shifted to EM and a lot more information was made available for Forecast. You need Forecast to run these reports using the reporting facility but I suspect that you can still access the data via SQL without it.
Try the tables
C<CODE>_RUNINFO
RUNINFO_HISTORY
AVG_RUN_INFO
Try the tables
C<CODE>_RUNINFO
RUNINFO_HISTORY
AVG_RUN_INFO
statistics
I'd suggest two things;
1. Upgrade - your version is out of support.
2. Run a query on the Control-M/Server database instead of the Control-M/EM database - the tables containing your data are CMR_AJF and CMR_JOBINF
Cheers.
1. Upgrade - your version is out of support.
2. Run a query on the Control-M/Server database instead of the Control-M/EM database - the tables containing your data are CMR_AJF and CMR_JOBINF
Cheers.
Upgrading to 6.4 or 7.0 is really recommended.
If you would like to have more advanced and easy to use capabilities for Control-M, check out VISUALjob for Control-M.
Here a link: http://www.apsware.com/control-m-soluti ... control-m/
If you would like to have more advanced and easy to use capabilities for Control-M, check out VISUALjob for Control-M.
Here a link: http://www.apsware.com/control-m-soluti ... control-m/