Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba jobs — различия между версиями

Материал из SQL эксперт
Перейти к: навигация, поиск
м (1 версия)
 
м (1 версия)
 
(нет различий)

Текущая версия на 10:08, 26 мая 2010

Query dba_jobs for job information

SQL>
SQL>
SQL> SELECT what, job, priv_user,
  2         TO_CHAR(last_date, "MM/DD/YYYY HH24:MI:SS") last,
  3         DECODE(this_date, NULL, "NO", "YES") running,
  4         TO_CHAR(next_date, "MM/DD/YYYY HH24:MI:SS") next,
  5         interval, total_time, broken
  6  FROM   dba_jobs
  7  where rownum < 50
  8  ORDER BY what;
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
GATHER_MY_STATS;
       141 sqle                                             NO
07/25/2008 18:06:31
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
TRUNC(SYSDATE+1) + 3/24
         1 N

WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
GATHER_MY_STATS;
        41 sqle                                             NO
07/26/2008 03:00:00
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
TRUNC(SYSDATE+1) + 3/24
         1 N

WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
LOG_SOURCE;
        61 sqle                                             NO
07/25/2008 18:34:31
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
SYSDATE + 1/24
         1 N

WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
LOG_SOURCE;
       161 sqle                                             NO
07/25/2008 17:50:04
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
SYSDATE + 1/24
         0 N

WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
P_RUN_INSERT;
       101 sqle                                             NO
01/01/4000 00:00:00
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
SYSDATE + (10/(24*60*60))
         2 Y

WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
P_RUN_INSERT;
       121 sqle                                             NO
01/01/4000 00:00:00
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
SYSDATE + (10/(24*60*60))
         3 Y

WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
P_RUN_INSERT;
       122 sqle                                             NO
01/01/4000 00:00:00
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
SYSDATE + (10/(24*60*60))
         2 Y

WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
P_RUN_INSERT;
        22 sqle                                             NO
01/01/4000 00:00:00
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
SYSDATE + (10/(24*60*60))
         0 Y

WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
P_RUN_INSERT;
        21 sqle                                             NO
01/01/4000 00:00:00
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
SYSDATE + (10/(24*60*60))
         3 Y

WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
analyze_my_tables;
        82 sqle                         07/25/2008 17:34:31 NO
07/26/2008 03:00:00
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
trunc(sysdate)+1+3/24
         5 N

WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
wwv_flow_cache.purge_sessions(p_purge_sess_older_then_hrs => 24);
      4001 FLOWS_020100                   07/25/2008 17:34:31 NO
07/26/2008 01:34:31
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
sysdate + 8/24
        12 N

WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
wwv_flow_mail.push_queue(wwv_flow_platform.get_preference("SMTP_HOST_ADDRESS"),w
wv_flow_platform.get_preference("SMTP_HOST_PORT"));
      4002 FLOWS_020100                   07/17/2008 19:37:40 NO
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -
01/01/4000 00:00:00
sysdate + 10/1440
        16 Y
WHAT
--------------------------------------------------------------------------------
       JOB PRIV_USER                      LAST                RUN
---------- ------------------------------ ------------------- ---
NEXT
-------------------
INTERVAL
--------------------------------------------------------------------------------
TOTAL_TIME B
---------- -

12 rows selected.
SQL>
SQL>
Источник — «http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/dba_jobs&oldid=3922»