| |
 |
|
Oracle Tips by Burleson |
Chapter 4 -
Chaining Oracle Jobs Together
Conditional Job Runs Using Oracle Advanced
Queuing
EXEC DBMS_SCHEDULER.run_job ('job_chain_aq_task_1');
-- Pre Oracle10g
/*
BEGIN
DBMS_JOB.isubmit (
job => 1000,
what => 'BEGIN job_chain_aq.task_1;
END;',
next_date => SYSDATE,
interval => 'TRUNC(SYSDATE) + INTERVAL ''1
6'' DAY TO HOUR');
DBMS_JOB.isubmit (
job => 1001,
what => 'BEGIN job_chain_aq.task_2;
END;',
next_date => SYSDATE,
interval => 'TRUNC(SYSDATE) + INTERVAL ''1
12'' DAY TO HOUR');
DBMS_JOB.isubmit (
job => 1002,
what => 'BEGIN job_chain_aq.task_3;
END;',
next_date => SYSDATE,
interval => 'TRUNC(SYSDATE) + INTERVAL ''1
18'' DAY TO HOUR');
COMMIT;
END;
/
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
