Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

restartable scheduler job does not restart after has failed

608723Nov 15 2007 — edited Nov 20 2007

Hi,

I have created a restartable scheduler job, running daily at 2am, which calls a stored procedure.
In some cases (dependent process in progress) the stored procedure can raise an user defined application error.
When an application error has raised, the job has failed and it is not restarted after 1,10,100,.. seconds, but waits until the next scheduled time (2am on the next day).

Can anyone help me please?

thanks,
Sylvia

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2007

Added on Nov 15 2007

#database-key-features, #scheduler

3 comments

3,836 views