DBMS_JOB.BROKEN

Oracle DBMS_JOB.BROKEN

Oracle allows you to mark a job you own as broken using the Oracle DBMS_JOB.BROKEN statement. The following is an example of the DBMS_JOB.BROKEN statement:

EXEC DBMS_JOB.BROKEN(52,TRUE);

The above DBMS_JOB.BROKEN statement will mark Job number 52 as broken.

If the job you are marking as broken with the DBMS_JOB.BROKEN statement is running at the time execution the job will continue to run until stopped. If you are unable to stop the job you may wish to kill your Oracle session.

If a job has been marked as broken with DBMS_JOB.BROKEN, or has been marked as broken by Oracle, Oracle will not attempt to execute the job until the broken status has been removed or the the job has been forced to execute.

To force a job marked as broken, using the  DBMS_JOB.BROKEN statement, the following command can be used:

EXEC DBMS_JOB.RUN(52);

You remove the broken status from a job that has been marked as broken with  DBMS_JOB.BROKEN with the following syntax:

EXEC DBMS_JOB.BROKEN(52,FALSE);

 

For more information on topics related to Oracle DBMS_JOB.BROKEN, please visit the following links:

DBMS_JOB
Oracle DBMS_JOB.REMOVE

 

---