Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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 RNTSOFT          RNTSOFT                               16-JUN-2008 17:30:19          0 RNTSOFT          RNTSOFT                               16-JUN-2008 17:30:19          0 4 rows selected. SQL> SQL> --