DB:10.2.0.3
OS:AIX
one of my job has been failed many time. How to check why the job is failing. I don't have permission to see the alert.log. Is there any dictionary views/tables to see the reason for the failed jobs.
SQL> SELECT FAILURES, JOB FROM DBA_JOBS;
FAILURES JOB
---------- ----------
0 2
23 45