How to count jobs (app. XX) in AJF before NDP - old AJF

A lot of scripts ans example to extract information from Control-M tools.
Post Reply
User avatar
bikin
Nouveau
Nouveau
Posts: 3
Joined: 12 Dec 2011 12:00

How to count jobs (app. XX) in AJF before NDP - old AJF

Post by bikin » 07 Aug 2013 3:19

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.

User avatar
Manii
Nouveau
Nouveau
Posts: 46
Joined: 28 Jul 2011 12:00

Post by Manii » 08 Aug 2013 4:45

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

Post Reply