2 Replies Latest reply: Feb 6, 2013 4:09 AM by user10243788 RSS

    scheduling job to run  every 45 minutes

    user10243788
      Hi, i have to execute a batch evert 45 minutes, everyday except friday.

      i gave the below but its executing evey hourly i.e 60 min not 45 min, can some1 plz help

      BEGIN
      DBMS_SCHEDULER.create_job (
      job_name => 'JOB',
      job_type => 'PLSQL_BLOCK',
      job_action => 'BEGIN JOB; END;',
      start_date => SYSTIMESTAMP,
      repeat_interval => 'FREQ=DAILY; BYDAY=MON,TUE,WED,THU,SAT,SUN;BYHOUR=9,10,11,12,13,14,15,16,17,18,19,20,21; BYMINUTE=45;',
      end_date => NULL,
      enabled => TRUE,
      comments => 'TO test proc');
      END;
      /