Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba jobs — различия между версиями
Admin (обсуждение | вклад) м (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>