Page 1 of 1
Job Statistics
Posted: 29 Jun 2011 4:26
by futre25
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.
SQL SCRIPTS
Posted: 30 Jun 2011 12:22
by brownbag
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
Posted: 30 Jun 2011 11:15
by futre25
Hi, and thanks for your reply.
My versíon is 6.1.3.
For this version, you have a query, because I do not find any tables in the 6.1.3 with related that you have written.
Thanks for avance.
statistics
Posted: 01 Jul 2011 12:09
by brownbag
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.
Posted: 01 Jul 2011 9:54
by Walty
Hi,
Try to look this
post
Like brownbag answer : one upgrade is recommended
Posted: 01 Jul 2011 1:19
by pht64
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/
Posted: 04 Jul 2011 2:29
by futre25
Thanks very much to all.
Most wanted migrate to Control-M 6.4 or 7.0, but my company does not want yet.
Can you tell me the changes and improvements to the Control-M 6.4 or 7.0.
I would greatly appreciate it.
Posted: 04 Jul 2011 2:29
by futre25
Thanks very much to all.
Most wanted migrate to Control-M 6.4 or 7.0, but my company does not want yet.
Can you tell me the changes and improvements to the Control-M 6.4 or 7.0.
I would greatly appreciate it.