Page 1 of 1

list jobs by nodeid

Posted: 15 Jun 2013 7:15
by neocox
Hi,

I'm new to control-m job scheduling and i would like to know how to get the list of jobs assigned to an agent from command line, maybe using ctmstats (nodeid filter)? but this is for statistics....

Thanks in avance.

Posted: 18 Jun 2013 3:56
by Manii
Hi,

If you want to get list of jobs on node id use below sql command on control-M server

#sql <enter>

> select JOBNAME, NODEID from CMS_JOBDEF ;


----------------------------------

If you dont have access to Control-M server and DB , you can see a default View point on Control-M/EM to load all jobs with Node ID , then you can change the view using menu option View -> List View
then export list into excel sheet

Hope this help

Regards,
Chandramani

Posted: 19 Jun 2013 8:50
by wer230518
You can play with the ctmruninf utility from command prompt
ctmruninf -list "*" -nodeid "nodeidname" -total
You can also redirect the output to a file.

or

In the Control-M/EM go to File - Open Viewpoint - select Dynamic Filter - in the Additional Tab add the Node ID name - select OK - Select the Viewpoint type and then OK

You will see that in the Node ID column it only shows the specific node id name.

Posted: 21 Jun 2013 8:29
by neocox
Thanks, it's perfect to me (using ctmruninf).