dbms_job Oracle10g dbms_scheduler Chaining Oracle Jobs Conditional Job Runs Custom Table Solution job_chain

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 a Custom Table Solution

INSERT INTO job_chain_locks (task_name, locked, retries, retry_delay)
VALUES ('task_2', 'Y', 5, 1);

INSERT INTO job_chain_locks (task_name, locked, retries, retry_delay)
VALUES ('task_3', 'Y', 3, 1);

COMMIT;

The contents of the job_chain_locks table can be monitored using the job_chain_locks_query.sql script.

job_chain_locks_query.sql

-- *************************************************
-- Copyright © 2005 by Rampant TechPress
-- This script is free for non-commercial purposes
-- with no warranties. Use at your own risk.
--
-- To license this script for a commercial purpose,
-- contact info@rampant.cc
-- *************************************************

select
*
from
job_chain_locks

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