dbms_job Oracle10g dbms_scheduler Chaining Oracle Jobs Conditional Job Runs Oracle Advanced Queuing job_chain_aq_setup dbms_aqadm Advanced Queueing job_chain_queue

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 4 - Chaining Oracle Jobs Together

Conditional Job Runs Using Oracle Advanced Queuing

PL/SQL procedure successfully completed.

SQL> @job_chain_query.sql

CREATED_TIMESTAMP TASK_NAME
--------------------------- --------------------
07-AUG-2004 18:18:36.136000 TASK_1
07-AUG-2004 18:23:08.771000 TASK_2
07-AUG-2004 18:26:04.972000 TASK_3

3 rows selected.

SQL> @job_chain_aq_query.sql

no rows selected

If manually attempting to start jobs out of sequence; the sessions hang until the appropriate message is sent.

Conditional Job Runs using a Custom Table Solution

If none of the previous methods seem suitable, a specific solution to meet specific needs can always be built.. The following example could be used as a starting point for such a solution.

The above text is an excerpt from:

Oracle Job Scheduling
Creating Robust Task Management with dbms_job and Oracle10g dbms_scheduler

ISBN 0-9744486-6-4

by Dr. Timothy S. Hall

http://www.rampant-books.com/book_2005_1_scheduling.htm

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.

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books