This content has been marked as final. Show 2 replies
Named schedules can be used when many jobs share them. In case of one job you can set start_date, repeat_interval and end_date for job. But instead of using complex sql expressions, you can use easy calendaring syntax.
JOB_TYPE should be STORED_PROCEDURE
job_type => 'stored_procedure',
start_date=> trunc(sysdate) + 5/24,
repeat_interval => 'FREQ=DAILY; BYHOUR=5',
enabled => true, auto_drop=> false,
comments => 'Converted from job 123'
Edited by: user503635 on Dec 28, 2012 1:05 AM