| |
 |
|
Oracle Tips by Burleson |
Chapter 4 -
Chaining Oracle Jobs Together
Conditional Job Enabling
DBMS_SCHEDULER.create_job (
job_name =>
'job_chain_enable_task_1',
job_type => 'STORED_PROCEDURE',
job_action =>
'job_chain_enable.task_1',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=daily; byhour=6;
byminute=0; bysecond=0;',
end_date => NULL,
enabled => TRUE,
comments => 'First task in the
enable chain.');
END;
/
BEGIN
DBMS_SCHEDULER.create_job (
job_name =>
'job_chain_enable_task_2',
job_type => 'STORED_PROCEDURE',
job_action =>
'job_chain_enable.task_2',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=daily; byhour=12;
byminute=0; bysecond=0;',
end_date => NULL,
enabled => FALSE,
comments => 'Second task in the
enable chain.');
END;
/
|
