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:

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.


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

You are commenting using your 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