Jobs in control m server and application

cypress · Post by **cypress** » 11 Jun 2010 7:15

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

hipikll · Post by **hipikll** » 11 Jun 2010 7:44

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

cypress · Post by **cypress** » 14 Jun 2010 12:02

Hi,

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

Regards,

cypress · Post by **cypress** » 15 Jun 2010 2:56

hello,

Someone can help me for this question?

regards

Walty · Post by **Walty** » 15 Jun 2010 4:32

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

baralem · Post by **baralem** » 16 Jun 2010 7:25

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

cypress · Post by **cypress** » 19 Jun 2010 9:58

hi,

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

Regards,

cypress · Post by **cypress** » 23 Jun 2010 12:29

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,

philmalmaison · Post by **philmalmaison** » 23 Jun 2010 4:15

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