Oracle7 Server Distributed Systems Volume II: Replicated Data

Broken Jobs

A job is labeled as either broken or not broken. Oracle does not attempt to run broken jobs. However, you can force a broken job to run by calling the procedure DBMS_JOB.RUN.

When you submit a job, it is considered not broken.

How Jobs Become Broken

There are two ways a job can break:

Oracle has failed to successfully execute the job after 16 attempts.

You have marked the job as broken, using the procedure DBMS_JOB.BROKEN.