Problem Description:
Job stays in 'Running' status, never complete and can't delete from OEM Grid Control.
1. How to find the job_id:
connect sysman@poem
select job_id
from mgmt_job
where job_name = 'BACKUP_ODS_ARCH_2HRS'
and job_owner = 'SYSMAN';
2. How to stop running job:
connect sysman@poem
exec mgmt_job_engine.stop_all_executions_with_id('459582F20C8B6AF4E0403E0ACECC4DCB',TRUE);
commit;
3. How to delete the job:
connect sysman@poem
exec mgmt_job_engine.delete_job('BACKUP_ODS_ARCH_2HRS','SYSMAN');
commit;
Reference:
Note:430626.1
Note:404211.1
Subscribe to:
Post Comments (Atom)
2 comments:
Thanks Vijay for the post...It helped in need
Thank you Vijay. Your blog has helped me with an issue with an OEM upgrade. I have referenced your blog in my blog on "Checks if GVM Performance collection job is running". Thank you again for your good work.
Post a Comment