dbTalk Databases Forums  

DBMS_SCHEDULER failed jobs

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss DBMS_SCHEDULER failed jobs in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
yorky
 
Posts: n/a

Default DBMS_SCHEDULER failed jobs - 07-21-2006 , 09:22 AM






Hi,

Possibly a daft question, but I can't seem to find the answer anywhere.
If I submit a job via dbms_scheduler, and it fails (for whatever
reason) will it autmaically resubmit or, or do I have to set the
restartable attribute? (the job will only have to run once btw).

If I have to set the restartable parameter, do I have to create the job
with dbms_scheduler, with a status of disabled, set the restartble
attribute, and then start the job by setting it to enabled? This does
seema bit daft to me, but from what I can see, I can't set the
restartable attribute when I create the job (which will run as soon as
it's been created).

TIA

Bryan


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.