Job Statistics

Some examples running with Control-M and Control-EM database.
Post Reply
User avatar
futre25
Nouveau
Nouveau
Posts: 166
Joined: 11 Aug 2009 12:00

Job Statistics

Post by futre25 » 29 Jun 2011 4:26

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.

User avatar
brownbag
Nouveau
Nouveau
Posts: 161
Joined: 11 Oct 2007 12:00
Location: Melbourne

SQL SCRIPTS

Post by brownbag » 30 Jun 2011 12:22

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

User avatar
futre25
Nouveau
Nouveau
Posts: 166
Joined: 11 Aug 2009 12:00

Post by futre25 » 30 Jun 2011 11:15

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.

User avatar
brownbag
Nouveau
Nouveau
Posts: 161
Joined: 11 Oct 2007 12:00
Location: Melbourne

statistics

Post by brownbag » 01 Jul 2011 12:09

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.

User avatar
Walty
Nouveau
Nouveau
Posts: 473
Joined: 20 Jan 2006 12:00

Post by Walty » 01 Jul 2011 9:54

Hi,

Try to look this post
Like brownbag answer : one upgrade is recommended
Best regards
Walty

User avatar
pht64
Nouveau
Nouveau
Posts: 22
Joined: 26 Sep 2007 12:00
Location: Germany
Contact:

Post by pht64 » 01 Jul 2011 1:19

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/

User avatar
futre25
Nouveau
Nouveau
Posts: 166
Joined: 11 Aug 2009 12:00

Post by futre25 » 04 Jul 2011 2:29

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.

User avatar
futre25
Nouveau
Nouveau
Posts: 166
Joined: 11 Aug 2009 12:00

Post by futre25 » 04 Jul 2011 2:29

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.

Post Reply