DB version: 11.2.0.4
For the below mentioned scheduler job, I need to change the start_date from '31-05-2013 00:15:00' to '31-08-2017 22:15:00' . Keep all other attributes unchanged.
Is there a way to alter this scheduler setting ? Or, I just have to drop and re-create this Job with required start date '31-08-2017 22:15:00' ?
begin
sys.dbms_scheduler.create_job(job_name => 'ACC_SYNC_JOB',
job_type => 'STORED_PROCEDURE',
job_action => 'ACC_CEL_SYNC',
start_date => to_date('31-05-2013 00:15:00', 'dd-mm-yyyy hh24:mi:ss'),
repeat_interval => 'Freq=HOURLY;Interval=2',
end_date => to_date('01-06-2035 00:15:00', 'dd-mm-yyyy hh24:mi:ss'),
job_class => 'DEFAULT_JOB_CLASS',
enabled => true,
auto_drop => true,
comments => 'Synch Cust Account');
end;
/