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 JAVA2S 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 JAVA2S 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 JAVA2S 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 JAVA2S 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 JAVA2S 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 JAVA2S 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 JAVA2S 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 JAVA2S 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 JAVA2S 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 JAVA2S 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>
| 30.34.dba_jobs |
| 30.34.1. | Query dba_jobs for job information |