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.
list jobs by nodeid
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
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
You can play with the ctmruninf utility from command prompt
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.
You can also redirect the output to a file.ctmruninf -list "*" -nodeid "nodeidname" -total
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.