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:
Post a Comment