This content has been marked as final. Show 10 replies
First, you can test this simple code if you want to. just create a dummy procedure that inserts to a dummy table and then schedule it. that's all...
secondly, "exec TEST_PROCEDURE;" is wrong you will just write name of the procedure.
After your all comments and reading some documnets I have changed only "JOB_ACTION" and "‘freq=daily" parameter which is given below :
job_name => 'TEST_JOB',
job_type => 'STORED_PROCEDURE',
job_action => TEST_PROCEDURE',
start_date => SYSTIMESTAMP,
repeat_interval => *‘freq=daily;* 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.');
I think this must work and suppose i want to run this from tommorrow, not nw then what should i mentioned?