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

    -- Uncomment the following line to force a failure.
    --RAISE_APPLICATION_ERROR(-20000,
    -- 'This is a fake error to prevent task_3 being executed');

    -- The work has completed successfully so unlock task_3
    lock_task ('task_3', FALSE);
END IF;

EXCEPTION
WHEN OTHERS THEN
    -- Don't unlock task_3.
    NULL;
END task_2;
-- -----------------------------------------------------------------

-- -----------------------------------------------------------------
PROCEDURE task_3 AS
-- -----------------------------------------------------------------
BEGIN

IF unlocked('task_3') THEN
    lock_task ('task_3');

    INSERT INTO job_chain (created_timestamp, task_name)
    VALUES (systimestamp, 'TASK_3');
    COMMIT;
END IF;

END task_3;
-- -----------------------------------------------------------------

-- -----------------------------------------------------------------

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