|
 |
|
Oracle Tips by Burleson |
Chapter 4 -
Chaining Oracle Jobs Together
Conditional Job Enabling
USER_JOBS
no rows selected
Next, run the third job manually. The results
below show that the third task has run successfully.
SQL> exec dbms_scheduler.run_job
('job_chain_enable_task_3');
PL/SQL procedure successfully completed.
SQL> @job_chain_query.sql
CREATED_TIMESTAMP TASK_NAME
---------------------------
--------------------
07-AUG-2004 13:52:28.227000 TASK_1
07-AUG-2004 13:59:16.666000 TASK_2
07-AUG-2004 14:02:10.948000 TASK_3
3 rows 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.200000 +01:00
JOB_CHAIN_ENABLE_TASK_3 TRUE 07-AUG-2004
18:00:00.700000 +01:00
3 rows selected.
|
