About System Status Updates

Submitted jobs can contain any of the following system status settings:

• SUBMITTED indicates the job has been submitted, but has not yet started. The DBMS_JOB does not guarantee immediate starting of jobs.

• IN PROGRESS indicates that the DBMS_JOB has started the process.

• COMPLETED indicates the job has finished.

• BROKEN (sqlcode) sqlerrm indicates there was a problem in your job that resulted in an error. The SQL code and SQL error message for the error should be included in the system status. Review this information to determine what went wrong.