Wednesday, July 22, 2009

Repair broken jobs in dba_jobs

Query dba_jobs for jobs that are broken :

sqlplus '/as sysdba'

SQL> select job, what from dba_jobs where broken='Y';

JOB OWNER WHAT
--- ----- -----------------
2 SCOTT Job1
3 SCOTT Job2

Connect as owner of the job :

sqlplus scott/tiger

SQL> exec DBMS_JOB.BROKEN(2,FALSE);

PL/SQL procedure successfully completed.

SQL> exec DBMS_JOB.BROKEN(3,FALSE);

PL/SQL procedure successfully completed.

sqlplus '/as sysdba'

SQL> select job, what from dba_jobs where broken='Y';

No rows selected.

No comments: