list jobs by nodeid

neocox · Post by **neocox** » 15 Jun 2013 7:15

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.

Manii · Post by **Manii** » 18 Jun 2013 3:56

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

wer230518 · Post by **wer230518** » 19 Jun 2013 8:50

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.

neocox · Post by **neocox** » 21 Jun 2013 8:29

Thanks, it's perfect to me (using ctmruninf).