It is currently 27 Jun 2017 8:20


Post new topic  Reply to topic  [ 8 posts ] 
Author Message
 Post subject: Job Statistics
PostPosted: 30 Jun 2011 12:26 
Offline
Nouveau
Nouveau
User avatar

Joined: 11 Aug 2009 8:00
Posts: 166
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.


Top
   
 Post subject: SQL SCRIPTS
PostPosted: 30 Jun 2011 8:22 
Offline
Nouveau
Nouveau
User avatar

Joined: 11 Oct 2007 8:00
Posts: 161
Location: Melbourne
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


Top
   
 Post subject:
PostPosted: 30 Jun 2011 7:15 
Offline
Nouveau
Nouveau
User avatar

Joined: 11 Aug 2009 8:00
Posts: 166
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.


Top
   
 Post subject: statistics
PostPosted: 01 Jul 2011 8:09 
Offline
Nouveau
Nouveau
User avatar

Joined: 11 Oct 2007 8:00
Posts: 161
Location: Melbourne
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.


Top
   
 Post subject:
PostPosted: 01 Jul 2011 5:54 
Offline
Nouveau
Nouveau
User avatar

Joined: 20 Jan 2006 9:00
Posts: 473
Hi,

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

_________________
Best regards
Walty


Top
   
 Post subject:
PostPosted: 01 Jul 2011 9:19 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Sep 2007 8:00
Posts: 21
Location: Germany
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/


Top
   
 Post subject:
PostPosted: 04 Jul 2011 10:29 
Offline
Nouveau
Nouveau
User avatar

Joined: 11 Aug 2009 8:00
Posts: 166
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.


Top
   
 Post subject:
PostPosted: 04 Jul 2011 10:29 
Offline
Nouveau
Nouveau
User avatar

Joined: 11 Aug 2009 8:00
Posts: 166
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.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 8 posts ] 

All times are UTC+10:00


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved