DBMS_JOB Auto-Rerun Behaviour

Hello there,

I have a question about the DBMS_JOB auto-rerun behaviour in an Oracle 8i (8.1.7.4.1) database.

We have a job running that will fail if the job has already been executed successfully for a user-specified reporting period. When this occurs, we raise a user-defined exception via the RAISE_APPLICATION_ERROR procedure.

My boss has asked me if it's possible to prevent the Oracle job queue from attempting to re-run the job. I think it will do this up to a maximum of 16 times (Think it's 16; might be 15) before the job will be marked as broken. Can this default behaviour be changed?

I suspect I know the answer to this question already, i.e. why would you want this behaviour to be changed when such a change would affect every job running in the database, including those you want the job queue to attempt to re-run if they fail once.

I have already advised my boss of my gut feeling on this, but to show willing, am submitting it to a wider Oracle audience.

I have advised my boss that we will probably have to get around this issue by using the DBMS_JOB.BROKEN procedure to mark the job as broken after it has run once successfully.

Over to you anyway.

Thanks in advance.

James Received on Mon Jan 16 2006 - 04:18:55 CST