Hi,
I have few jobs in CM/EM which shows executing(yellow) stage and i need to delete them.I logged into sql DB and issued 'delete from CMR_AJF where ORDERNO IN(<>,<>)'
Query executed fine and the data is deleted in sql server DB but I still could able to see those jobs in my CM/EM screen.By browsing few forums later,I came to know that I followed an incorrect procedure to delete the jobs with executing state.
I am wondering is there any other way that I can get rid of those jobs.
Thanks in Advance!
wrong Delete procedure used!!
Hi,
If you have jobs in execution state, and you want to delete them , use the <kill> option from the GUI :
- select your job
- right click
- select kill
- confirm action
Other possibility is to invoque the <ctmkilljob> in command line.
The ctmkilljob utility terminates a specified CONTROL-M job and all its processes.
ctmkilljob terminates only jobs that are currently executing.
usage: ctmkilljob
[ -ORDERID <unique order ID> ]
[ -NODEID <name> ]
[ -MEMLIB <path> ]
[ -MEMNAME <filename> ]
[ -JOBNAME <name> ]
If you have jobs stuck in yellow (running) status on GUI but no active processes on agent box, the status never changes for those jobs until you manually update the status in the Control-M/Server Database (SQL query). In this forum you find some tips about this cases (search <yellow> word)
Tips:
When you modify table CMR_AJF by SQL, good way is to execute <force download> to syncronise Control-M/Server and Control-M/EM DB :
From user <controlm> invoked the <reset_ecs> script or use ctm_menu --> Troubleshooting --> Force Download
If you have jobs in execution state, and you want to delete them , use the <kill> option from the GUI :
- select your job
- right click
- select kill
- confirm action
Other possibility is to invoque the <ctmkilljob> in command line.
The ctmkilljob utility terminates a specified CONTROL-M job and all its processes.
ctmkilljob terminates only jobs that are currently executing.
usage: ctmkilljob
[ -ORDERID <unique order ID> ]
[ -NODEID <name> ]
[ -MEMLIB <path> ]
[ -MEMNAME <filename> ]
[ -JOBNAME <name> ]
If you have jobs stuck in yellow (running) status on GUI but no active processes on agent box, the status never changes for those jobs until you manually update the status in the Control-M/Server Database (SQL query). In this forum you find some tips about this cases (search <yellow> word)
Tips:
When you modify table CMR_AJF by SQL, good way is to execute <force download> to syncronise Control-M/Server and Control-M/EM DB :
From user <controlm> invoked the <reset_ecs> script or use ctm_menu --> Troubleshooting --> Force Download
Best regards
Walty
Walty
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France
it is not recommended to delete from CMR_AJF, or in that case, you must know what is the on delete cascade ...
it is very dangerous to directly delete frm CMR_AJF
use the ctmkilljob, and use Hold/free job after that to change the status from yellow to red, then wait for the new day procedure to remove them as necessary.
regards
philmalmaison
it is very dangerous to directly delete frm CMR_AJF
use the ctmkilljob, and use Hold/free job after that to change the status from yellow to red, then wait for the new day procedure to remove them as necessary.
regards
philmalmaison