Re: DBMS_JOB Auto-Rerun Behaviour

Jimbo1 wrote:
> 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

I think you've got it. Though the last time I saw Oracle 8i was many years ago.

Perhaps suggest to your boss it will be easy to handle is a currently supported version of Oracle. ;-)

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)