10 Replies Latest reply: Jul 30, 2012 7:35 AM by Santosh Pradhan RSS

    Job creation on particular days in week

    Santosh Pradhan
      hi All,


      OS : RHEL 5.7
      DB : 11.2.0.2

      I have created one job. I want to run one procedure from Monday to Saturday at 10AM.

      Below is my code.

      Please check the code and tell me is it correct because i dont have that much idea about scheduling a job.

      have i wrote that "job_action" section rightly? -- "TEST_PROCEDURE" is my procedure.

      BEGIN
      DBMS_SCHEDULER.create_job (
      job_name => 'TEST_JOB',
      job_type => 'STORED_PROCEDURE',
      job_action => 'exec TEST_PROCEDURE;',
      start_date => SYSTIMESTAMP,
      repeat_interval => ‘freq=weekly; byday=mon,tue,wed,thur,fri,sat; byhour=10; byminute=0; bysecond=0;’,
      end_date => NULL,
      enabled => TRUE,
      comments => 'Procedure will run From Mon to SAT at 10 AM.');
      END;
      /



      Regards.