Specifying when a failed job is to retry running

Using Oracle's DBMS_SCHEDULER is there any way to specify when a failed job is to retry running again?  Our scheduled jobs are of the variety that if they fail, we would like to wait an hour before retrying running them again.  The Oracle online documentation on this seems to indicate that a scheduled job fail will be instantly retried to run again (up to max num retries).

              DBMS_SCHEDULER.CREATE_JOB (
                job_name            => strJobName
               ,job_type              => strJobType
               ,job_action          => strJobAction
               ,number_of_arguments => 1
               ,start_date          => dteStart
               ,end_date            => dteEnd
               ,repeat_interval     => 'FREQ=HOURLY;INTERVAL=1'
               ,enabled             => FALSE
               ,auto_drop           => FALSE
               ,comments            => strComments
              );
             
              DBMS_SCHEDULER.set_attribute (
                name        => strJobName
               ,attribute   => 'max_failures'
               ,value       =>  numMaxRetryAttempts
              );
crayola3Asked:
Who is Participating?
 
crayola3Author Commented:
Confirms what I had thought about how retry works for dbms_scheduler.
0
 
DavidSenior Oracle Database AdministratorCommented:
I have to concur that the restart cannot be deferred -- except in the following condition:

If restartable is set to FALSE for the job:
If the job is a run-once job and auto_drop is set to TRUE, the job run is done and the job is dropped.
If the job is a run-once job and auto_drop is set to FALSE, the job is disabled and the job state is set to 'STOPPED'.
If the job is a repeating job, the Scheduler schedules the next job run and the job state is set to 'SCHEDULED'.
 
0
 
DavidSenior Oracle Database AdministratorCommented:
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
in simple terms, there is no answer as of now for your requirement with 10g dbms_scheduler. I mean dbms_scheduler does not have an option for your requirement as far as i am aware. I wish to some option/solution to your requirement in oracle 11g version.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.