Бова Николай (Мик) Петрович (Chanting Wolf) (main_framer) wrote in oracle_ua,
Бова Николай (Мик) Петрович (Chanting Wolf)
main_framer
oracle_ua

Oracle chains (DBMS_SCHEDULER.CREATE_CHAIN)

DBMS_SCHEDULER.CREATE_CHAIN

PL/SQL
Packages and Types Reference

http://www.oracle.com/technology/software/index.html


Oracle® Database Administrator's Guide
11g Release 1 (11.1)
Using Chains
http://oracle.su/server.111/b28310/scheduse009.htm

Oracle Scheduler
Apps  DBA  Blog
http://www.appsdba.com/blog/?p=26

Examples of Creating Chains
http://oracle.su/server.111/b28310/schedadmin006.htm#BAJHFHCD

Handling Stalled Chains
http://oracle.su/server.111/b28310/scheduse009.htm#CHDIEDIJ

Scheduler in Oracle Database 10g
Programs
http://oracle.su/server.111/b28310/scheduse009.htm

CHAIN_LOG_ID
http://www.databasejournal.com/img/2006/03/Oracle_10g_Scheduler_Enhancements_Listing_2.html


//// CHAINS
SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS;
SELECT * FROM ALL_SCHEDULER_RUNNING_CHAINS;
SELECT * FROM dba_scheduler_chains;
SELECT * FROM dba_scheduler_chain_steps;
SELECT * FROM ALL_SCHEDULER_CHAIN_RULES;
SELECT * FROM dba_scheduler_programs;
SELECT * FROM dba_scheduler_chain_rules;

//// JOBS
SELECT * FROM ALL_SCHEDULER_JOB_LOG ORDER BY LOG_DATE DESC;
SELECT * FROM ALL_SCHEDULER_JOB_RUN_DETAILS ORDER BY LOG_DATE DESC;
SELECT * FROM dba_scheduler_job_log ORDER BY LOG_DATE DESC;
SELECT * FROM dba_scheduler_job_run_details ORDER BY LOG_DATE DESC;

SELECT SYSDATE FROM dual;
Tags: chains, oracle
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your IP address will be recorded 

  • 0 comments