Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Query dba_jobs for job information

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 RNTSOFT                                             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 RNTSOFT                                             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 RNTSOFT                                             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 RNTSOFT                                             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 RNTSOFT                                             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 RNTSOFT                                             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 RNTSOFT                                             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 RNTSOFT                                             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 RNTSOFT                                             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 RNTSOFT                         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>