It is currently 28 May 2017 10:31


Post new topic  Reply to topic  [ 2 posts ] 
Author Message
PostPosted: 07 Aug 2013 11:19 
Offline
Nouveau
Nouveau
User avatar

Joined: 12 Dec 2011 9:00
Posts: 3
Hi all,

I need help related to task when I have to count number of jobs with application XX* in AJF before NDP.

Normally, I open AJF in Archived Viewpoint wizard, use dynamic filter and check number of jobs.

But problem is that I need this data also for AJF which is older then 20days and these AJFs are not available in Archived ViewPoint Wizard.

Is it possible, somehow, get this data from DB or these data are lost by cleaning of CMR_AJF table?

Many thanks for help in advance.


Top
   
 Post subject:
PostPosted: 09 Aug 2013 12:45 
Offline
Nouveau
Nouveau
User avatar

Joined: 28 Jul 2011 8:00
Posts: 46
Hi ,

you can get all job count order on some particular date ( upto 90 days) using reporting facility -> workload report.
however for particular application job count is not available using this . :(

further now you can put a small script on your control-m server to count number of jobs everyday on particular application , and get sysout in email to your email id
=========================
SQL << EOF
select count(*) from CMR_AJF where APPLIC = 'XXAplication name' ;
EOF
==========================

:idea: run this script on control-m server with control-m server user , 4-5 min before NDP.

Hope this will help you :?:

Regards,
Chandramani


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

All times are UTC+10: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