Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba jobs
Query dba_jobs for job information
<source lang="sql">
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></source>