execute dbms_job.broken(125,false);





dbms_defer_sys.push(destination=>'DESTINATION.COM.AU');




SQL> select job, failures, broken, last_date, last_sec, next_date, next_sec from user_jobs;

       JOB   FAILURES BROKEN LAST_DATE LAST_SEC NEXT_DATE NEXT_SEC
---------- ---------- ------ --------- -------- --------- --------
         1          0 N      04/FEB/14 20:45:17 04/FEB/14 22:45:17
       125          0 N      04/FEB/14 21:51:33 04/FEB/14 22:21:33
        64          0 N      04/FEB/14 21:43:23 04/FEB/14 21:53:23
       145          0 N      04/FEB/14 21:43:28 04/FEB/14 21:53:28
       146          0 N      04/FEB/14 21:45:13 04/FEB/14 21:55:13
       147          0 N      04/FEB/14 21:45:13 04/FEB/14 21:55:13
       148          0 N      04/FEB/14 21:45:13 04/FEB/14 21:55:13
       149          0 N      04/FEB/14 21:43:58 04/FEB/14 21:53:58