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