Check for DBMS Scheduler Errors

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:

SingleRecordView

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s