 |
|
Oracle Tips by Burleson |
Chapter 4 -
Chaining Oracle Jobs Together
Conditional Job Creation
job_chain_create.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
--
*************************************************
CREATE OR REPLACE PACKAGE job_chain_create AS
PROCEDURE task_1;
PROCEDURE task_2;
PROCEDURE task_3;
END job_chain_create;
/
SHOW ERRORS
CREATE OR REPLACE PACKAGE BODY job_chain_create
AS
--
-----------------------------------------------------------------
PROCEDURE task_1 AS
--
-----------------------------------------------------------------
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
