This discussion is archived
10 Replies Latest reply: Jul 30, 2012 5:35 AM by Santosh Pradhan RSS

Job creation on particular days in week

Santosh Pradhan Explorer
Currently Being Moderated
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.');



  • Correct Answers - 10 points
  • Helpful Answers - 5 points