TO check status of broken job:
SQL> select job, broken,what from dba_jobs
JOB BROKEN WHAT
----- ------ ----
3 N PROC1;
2 Y PROC2;
Here the BROKEN column of job 2 is Y which means that this is a broken one.
To mark it as not broken:
EXEC DBMS_JOB.BROKEN(2,FALSE);
TO verify if the broken job is fixed.
SQL> select job, broken,what from dba_jobs
JOB BROKEN WHAT
--- ---- ----
3 N PROC1;
2 N PROC2;
