Want to remove the hang job from Control-M/EM

shiva2010 · Post by **shiva2010** » 09 Sep 2010 9:03

Hi,
For some testing I have executed 3-4 jobs and found that jobs were taking too much time so I tried to kill those jobs but I couldn't cause it was showing SAPR3 mode was not found after that I have changed the dbglvl to 0 0 and restarted the system itself but the jobs which I executed were showing in running status in control-m but from log it shows that job has been finished long back with creation of order id also but it was in yellow colout still that means its in hang status in control-m I want to remove this on job from Control-M/EM so what would be the way to remove it.

Thanks & Regards

Shiva J

philmalmaison · Post by **philmalmaison** » 09 Sep 2010 2:37

Hi,
it means that yuo've got a SAP/R3 <=> Controlm agent broken feedback.
So that jobs will stay in AJF from Control-M Server as long as you change there status in CMR_AJF table.

Do the following:
by login on controlm user do the following select:
(for sybase)
SQL -s << EOF
select ORDERNO from CMR_AJF
where
JOBNAME="<your>"
go
EOF

keep all concerned ORDERNO and do the following:

SQL -s << EOF
update CMR_AJF set STATE = '5', OSCOMPSTAT=1, STATUS='N' where ORDERNO = <Your>
go
EOF

when it's done for all jobs, hold them and free them , they will become in red status, and you can then hold/delete them.
the next NDP should do the rest...

regards
Philmalmaison