Oracle7 Server Distributed Systems Volume II: Replicated Data

Marking a Job as Broken or Not Broken

To mark a job as broken or not broken, use the procedure BROKEN in the DBMS_JOB package.

Marking a Job as Not Broken: Example

The following example marks job 14144 as not broken and sets its next execution date to the following Monday:

DBMS_JOB.BROKEN( job       => 14144, 
                 broken    => FALSE, 
                 next_date => NEXT_DAY(SYSDATE, 'MONDAY'));

Once a job has been marked as broken, Oracle will not attempt to execute the job until you either mark the job as not broken, or force the job to be executed by calling the procedure DBMS_JOB.RUN.

Restrictions

You can mark only jobs you own as broken. If you try to mark a job you do not own, you receive a message that states the job is not in the job queue.

Additional Information: The parameters for DBMS_JOB.BROKEN are described in Table 12 - 30.