Scheduler Usage
http://scheduler-usage.com/

How to count jobs (app. XX) in AJF before NDP - old AJF
http://scheduler-usage.com/viewtopic.php?f=12&t=3620
Page 1 of 1

Author:  bikin [ 07 Aug 2013 3:19 ]
Post subject:  How to count jobs (app. XX) in AJF before NDP - old AJF

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.

Author:  Manii [ 08 Aug 2013 4:45 ]
Post subject: 

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

Page 1 of 1 All times are UTC+02:00
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/