10 Replies Latest reply on Jul 30, 2012 12:35 PM by Santosh Pradhan

    Job creation on particular days in week

    Santosh Pradhan
      hi All,

      OS : RHEL 5.7
      DB :

      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.

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