Hi
Please assist if someone knows how to kill a job. I have a job the color is yellow, I thought job is executing but when i check the log Job is SUBMITTED only, tried to kill from the gui but cannot. How can i kill the job
How to kill a job
Hi,
On which platform is your job running ? (OS or Mainframe)
On OS I know about 2 options :
1) set your agent where job is submitted as unavailable via option ctm_menu or (if you're an administrator via configuration manager) and then back to available.
Normally your job will become white (state unknown) & afterwards red (cancelled).
2) This solution is very tricky and you'll have to be very carefull :
you'll have to logon to your control/m-database & change the STATUS-field on CMR_AJF for this job to Y instead of N, also put the STATE-field in the same table for the same job to 8 (finished) instead of 4 (executing) (watch out because this is really tricky).
On mainframe you can use the CTMCAJF function (also be carefull to not delete your entire CKP-file (AJF), read the ctm-manuals for this utility.
RoHoe.
On which platform is your job running ? (OS or Mainframe)
On OS I know about 2 options :
1) set your agent where job is submitted as unavailable via option ctm_menu or (if you're an administrator via configuration manager) and then back to available.
Normally your job will become white (state unknown) & afterwards red (cancelled).
2) This solution is very tricky and you'll have to be very carefull :
you'll have to logon to your control/m-database & change the STATUS-field on CMR_AJF for this job to Y instead of N, also put the STATE-field in the same table for the same job to 8 (finished) instead of 4 (executing) (watch out because this is really tricky).
On mainframe you can use the CTMCAJF function (also be carefull to not delete your entire CKP-file (AJF), read the ctm-manuals for this utility.
RoHoe.
Hi
Did you see topics ?
Job remain in executing (yellow) status?
or
Agent 6.2.01 - Job stay in executing mod
You shoud use search option !!
Did you see topics ?
Job remain in executing (yellow) status?
or
Agent 6.2.01 - Job stay in executing mod
You shoud use search option !!
Put the job ON HOLD first, open job editing form and under Active menu make a note of Job's Order Id (i.e.: 007n3)
Login to Control-M Server box using Controlm Server admin UNIX id and run this:
$p_36 <order_id>
$p_36 007n3
This will give you ORDERNO for that particular job.
Then, connect to Control-M SERVER database and run the following query:
SQL> select JOBNAME, MEMNAME from CMR_AJF where ORDERNO = <ORDERNO>
This is to make sure that it's the job that you want to kill.
Then do the following update:
SQL> update CMR_AJF set STATE = '5', OSCOMPSTAT=1, STATUS='N' where ORDERNO = <order_number>
Exit and release the job - it should turn red in a second (killed).
Login to Control-M Server box using Controlm Server admin UNIX id and run this:
$p_36 <order_id>
$p_36 007n3
This will give you ORDERNO for that particular job.
Then, connect to Control-M SERVER database and run the following query:
SQL> select JOBNAME, MEMNAME from CMR_AJF where ORDERNO = <ORDERNO>
This is to make sure that it's the job that you want to kill.
Then do the following update:
SQL> update CMR_AJF set STATE = '5', OSCOMPSTAT=1, STATUS='N' where ORDERNO = <order_number>
Exit and release the job - it should turn red in a second (killed).
- kaibiganmi
- Nouveau
- Posts: 12
- Joined: 27 Dec 2007 12:00
How to kill a job
thanks for help, It works fine now already killed now, space was full.