Loading....

MANUAL DELETION OF GRID CONTROL JOBS.

Sometimes GRID CONTROL jobs may show as RUNNING although they have completed.

This will restrain the job from returning to the ‘SCHEDULED’ state and thereby will not run.

To manually remove a job in the job queue from the backend –

Login to the repository owner in the Grid Control repository database –

Repository owner – SYSMAN

Repository database – EMREP

SYSMAN@emrep> select job_id, job_name, job_owner from mgmt_job where job_name like ‘%BACKUP%’;

JOB_ID
——————————–
JOB_NAME
—————————————————————-
JOB_OWNER
——————————————————————————–
5C153E5F858740BCE0430AFEC84040BC
TEST BACKUP

Firstly stop all executions of this job.

SYSMAN@emrep> exec mgmt_job_engine.stop_all_executions_with_id(‘5C153E5F858740BCE0430AFEC84040BC’,TRUE);

PL/SQL procedure successfully completed.

SYSMAN@emrep> commit;

Commit complete.

Finally remove this job from the job_management engine.

SYSMAN@emrep> exec mgmt_job_engine.delete_job(‘5C153E5F858740BCE0430AFEC84040BC’);

PL/SQL procedure successfully completed.

SYSMAN@emrep> commit;

Commit complete.

Please follow and like us:

Last Update: May 30, 2020  

July 13, 2009 68 Arjun Raja
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?