Query dba_job table : dba_job « System Tables Views « Oracle PL / SQL






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
JAVA2S          JAVA2S                               16-JUN-2008 17:30:19          0
JAVA2S          JAVA2S                               16-JUN-2008 17:30:19          0

4 rows selected.

SQL>
SQL> --

 








Related examples in the same category