Scheduler Usage

How to know the nember of jobs in a control m server and the number of jobs use by an application

you want to know the actual active jobs?
select count(*) from cmr_ajf [where ... application like ]

Hi,

I want to know the number of jobs (all jobs) on a control server and all jobs use in specific application.

Regards,

hello,

Someone can help me for this question?

regards

Hi,

Do you want to know the number of jobs defined in a CONTROL-M/Server or jobs in your AJF.

For AJF see the <ctmpsm> utility

ctmpsm -LISTALL [<ODAT|TIME|APPLICATION|MEMNAME|ALL|ALLFIELDS|ALLFIELDS_FULL>] [-SORT <ORDERID|JOBNAME>]

ie: ctmpsm -listall -sort jobname for all jobs
ie: ctmpsm -listall application for application/jobs

You can use after grep command ......

For definition in your CONTROL-M/Server use SQL query and see the <CMS_JOBDEF> table

Using SQL:

--Number of Jobs
select count(*) from CMS_JOBDEF

--Jobs by Application
select APPLIC, count(*)
from CMS_JOBDEF
group by APPLIC order by 2 desc


regards
martin

hi,

Thanks for these answers i will try it on tuesday and will tell you the result.

Regards,

Hi,

The result of this query is not consistent with information in the database of the em is this normal?

select APPLIC, count(*)
from CMS_JOBDEF
group by APPLIC order by 2 desc

Regards,

yes because CMS_JOBDEF is not an Enterprise Manager table, but a control-M server table, do it on the good server, it should work.
note that the number of jobs defined for a datacenter or a application, can not give a good idea of the number of run.
You must use statistixcs to do that.

regards$
philmalmaison