2 Replies Latest reply: Sep 20, 2013 3:57 PM by Kevin_K RSS

    Modify a schedule


      I have a hourly schedule set with name hourly_scheule which runs every day every hour, now I need to modify this to run every few hours and between specific time window.


      I don't how to add start and end time in the schedule



        DBMS_SCHEDULER.create_schedule (

          schedule_name   => 'DAILY_schedule',

          start_date      => SYSTIMESTAMP,

          repeat_interval => 'freq=hourly; INTERVAL=4 byminute=5',

          end_date        => NULL,

          comments        => 'Repeats every 2 hours, on the hour, for ever.');




      Please help.




      I need to specify start and endtime for each day, I don't see a argument for the same


      Message was edited by: Kevin_K