Hi Team,
I have created the dbms_scheduler ,if any failures are there in the my procedure ,need to retry the job base the max_failure option and also set the RESTARTABLE to true. still it is not working..
it is not running automatically if any failures.
sample code:
begin
DBMS_SCHEDULER.create_job (
job_name => 'test_full_job_definition',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN proc1; END;',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=daily; byminute=0',
end_date => NULL,
enabled => TRUE,
comments => 'Job defined entirely by the CREATE JOB procedure.');
end;
/
BEGIN
DBMS_SCHEDULER.SET_ATTRIBUTE( name => 'test_full_job_definition' ,
attribute => 'RESTARTABLE' ,
value => TRUE
);END;
begin
DBMS_SCHEDULER.set_attribute (
name => 'test_full_job_definition'
,attribute => 'max_failures'
,value => 4
);
end;
Thanks,