Oracle PL/SQL/System Tables Views/dba job

Query dba_job table

 
SQL>
SQL> column priv_user format a15
SQL> column schema_user format a15
SQL>
SQL> select priv_user,
  2             schema_user,
  3             this_date,
  4             next_date,
  5             decode( failures, null, 0, failures ) failures
  6        from dba_jobs
  7        where rownum < 50
  8      /
PRIV_USER       SCHEMA_USER     THIS_DATE            NEXT_DATE              FAILURES
--------------- --------------- -------------------- -------------------- ----------
FLOWS_020100    FLOWS_020100                         16-JUN-2008 23:06:50          0
FLOWS_020100    FLOWS_020100                         16-JUN-2008 17:39:23          0
sqle          sqle                               16-JUN-2008 17:30:19          0
sqle          sqle                               16-JUN-2008 17:30:19          0
4 rows selected.
SQL>
SQL> --