Database: Oracle 11g
I had a problem where a job I had scheduled didn’t appear to be working. The job itself compiled correctly, it showed no errors and I had no way of accessing the log files without going through my Sysadmin. This seemed to be a bit too much work, so after a little bit of Googling I found this query:
select
*
from
DBA_SCHEDULER_JOB_RUN_DETAILS
where
JOB_NAME = 'INSERT_JOB_NAME'
order by
LOG_DATE desc
Which returns the log table, which you can view table like this:
(Schema removed to protect customer identity)
This log table helps you identify whether the job ran, if it was successful and if there are any errors codes.
Edit:
Please be aware that if you copy this code directly into SQL Dev. it may not work due to unrecognized ASCII characters. Type it out instead and everything should be fine.