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

    Modify a schedule

    Kevin_K

      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

       

      BEGIN

        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.');

      END;

      /

       

      Please help.

       

      Thanks

       

      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