|
 |
|
Oracle Tips by Burleson |
Chapter 4 -
Chaining Oracle Jobs Together
Conditional Job Enabling
USER_JOBS
no rows selected
Finally, run the first job again to see that
the subsequent jobs have been enabled or disabled appropriately.
SQL> exec dbms_scheduler.run_job
('job_chain_enable_task_1');
PL/SQL procedure successfully completed.
SQL> @job_chain_query.sql
CREATED_TIMESTAMP TASK_NAME
---------------------------
--------------------
07-AUG-2004 14:03:55.683000 TASK_1
1 row selected.
SQL> @job_queue_query.sql
USER_SCHEDULER_JOBS
JOB_NAME ENABL NEXT_RUN_DATE
--------------------------- -----
----------------------------------
JOB_CHAIN_ENABLE_TASK_1 TRUE 08-AUG-2004
06:00:00.800000 +01:00
JOB_CHAIN_ENABLE_TASK_2 TRUE 08-AUG-2004
12:00:00.700000 +01:00
JOB_CHAIN_ENABLE_TASK_3 FALSE 07-AUG-2004
18:00:00.700000 +01:00
3 rows selected.
USER_JOBS
no rows selected
|
