Re: How to run Job in Oracle after failed

From: Andrew Hardy <junkmail_at_[127.0.0.1>
Date: Fri, 19 May 2006 08:59:03 +0100
Message-ID: <e4jts7$q76$1@sun-cc204.lut.ac.uk>

Resant wrote:

> At SQL Server, if a job failed, that job will still run again on next
> schedule, but not in Oracle.

If the job fails due to an exception, it will retry up to 16 times - there will be an increasing delay between the attempts. After the 16th run, the job will be marked as failed and will not be submitted into the schedule until it is marked as not failed.

When a job completes it will use the interval information to determine when it should next run - the interval is based on the completion time, not the initial run time.

It is possible to manually mark a job as failed to prevent it being run, it is also possible for the job to mark itself as failed - you might do this if a serious error occurs and you don't want the job to attempt to re-run.

-- 
Andy

Opinions are mine and do not necessarily reflect those of Advantica 
Technologies

Received on Fri May 19 2006 - 02:59:03 CDT