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
