Oracle PL/SQL/System Tables Views/dba job

Query dba_job table

   <source lang="sql">

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

</source>