Handling job failures

What happens when job fails

If a job fails, the job will try again at the next scheduled time.

What might cause failure

These are errors that happen in the database that lead to failure of the job.

For example, if someone has deleted mandatory data—the job fails because needed data does not exist. Oracle DB will fail and reported failures will appear in the Failure log.

No of failures

The number of times job has failed to complete successfully.

Reset failure count

The Reset failure count option will reset the failure count on the job. The option is available only when the job is active. If the number of failures is zero, it will not be able to reset and will show a message.

Reset failure count is disabled when the job is not active.