Oracle PL/SQL Tutorial/System Tables Data Dictionary/user jobs
Query user_jobs
<source lang="sql">
SQL> SQL> select job, to_char(sysdate,"dd-mon"),
2 to_char(next_date,"dd-mon-yyyy hh24:mi:ss"),
3 interval, what
4 from user_jobs
5 /
JOB TO_CHA TO_CHAR(NEXT_DATE,"D
------ --------------------
INTERVAL
WHAT
21 25-jul 01-jan-4000 00:00:00
SYSDATE + (10/(24*60*60)) P_RUN_INSERT;
22 25-jul 01-jan-4000 00:00:00
SYSDATE + (10/(24*60*60)) P_RUN_INSERT;
JOB TO_CHA TO_CHAR(NEXT_DATE,"D
------ --------------------
INTERVAL
WHAT
41 25-jul 26-jul-2008 03:00:00
TRUNC(SYSDATE+1) + 3/24 GATHER_MY_STATS;
61 25-jul 25-jul-2008 19:34:32
SYSDATE + 1/24
JOB TO_CHA TO_CHAR(NEXT_DATE,"D
------ --------------------
INTERVAL
WHAT
LOG_SOURCE;
101 25-jul 01-jan-4000 00:00:00
SYSDATE + (10/(24*60*60)) P_RUN_INSERT;
82 25-jul 26-jul-2008 03:00:00
JOB TO_CHA TO_CHAR(NEXT_DATE,"D
------ --------------------
INTERVAL
WHAT
trunc(sysdate)+1+3/24 analyze_my_tables;
121 25-jul 01-jan-4000 00:00:00
SYSDATE + (10/(24*60*60)) P_RUN_INSERT;
JOB TO_CHA TO_CHAR(NEXT_DATE,"D
------ --------------------
INTERVAL
WHAT
122 25-jul 01-jan-4000 00:00:00
SYSDATE + (10/(24*60*60)) P_RUN_INSERT;
141 25-jul 25-jul-2008 21:18:41
TRUNC(SYSDATE+1) + 3/24 GATHER_MY_STATS;
JOB TO_CHA TO_CHAR(NEXT_DATE,"D
------ --------------------
INTERVAL
WHAT
161 25-jul 25-jul-2008 19:46:13
SYSDATE + 1/24 LOG_SOURCE;
162 25-jul 25-jul-2008 19:49:44
SYSDATE + 1/24
JOB TO_CHA TO_CHAR(NEXT_DATE,"D
------ --------------------
INTERVAL
WHAT
LOG_SOURCE;
11 rows selected.</source>
