It is currently 19 Aug 2017 6:45


Post new topic  Reply to topic  [ 3 posts ] 
Author Message
PostPosted: 11 Jan 2012 12:11 
Offline
Nouveau
Nouveau
User avatar

Joined: 14 Jan 2010 12:00
Posts: 58
I have a job that was ordered on 1/1 with a max wait of 20.
I only keep archived viewpoints for 7 days.
I keep my sysout logs for 14 days and confirmed that the job ordered on 1/1 in the udly sysout log.
I can see in my archive viewpoint the job was gone on 1/3
The trigger for the job was not available until 1/5 so I know the job did not run.

My question is: Is there an utility or a way to query the database to see what happened to the job?


Top
   
 Post subject:
PostPosted: 11 Jan 2012 2:08 
Offline
Nouveau
Nouveau
User avatar

Joined: 07 Jul 2008 12:00
Posts: 23
You could dump your job's log from the table CMR_IOALOG in the Control-M/Server database if you retain enough days.

If you don't have enough retention, try restoring the backup directory of the Control-M/Agent which is supposed to have executed the batch and get your information from the dsect file.

Note: If the job hasn't been submitted you won't find any dsect file in that directory

If this is the case, your last chance is to ask your DBA to restore your database data on another database and consult the CMR_IOALOG table from there.

Cheers


Top
   
 Post subject:
PostPosted: 11 Jan 2012 4:50 
Offline
Nouveau
Nouveau
User avatar

Joined: 14 Jan 2010 12:00
Posts: 58
Thank-you!

I was able to use the IOALOG table to aid in finding the job disapeared due to another job in a completely different scheduling group having the exact same out condition as the predecessor of the job that vanished. This caused the job to run on 1/1 and be removed from the AJF on the 1/2 newday, instead of waiting for the trigger.


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

All times are UTC+02:00


Who is online

Users browsing this forum: No registered users and 1 guest


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