Monday, April 8, 2013

ORA-12012: error on auto execute of job : ORA-01878: specified field not found in datetime or interval


You may see the below errors in your alert log file after the daylight time changes if the job happens to run around
the time when the daylight time changes, which is 2 AM.

ORA-12012: error on auto execute of job 219820676
ORA-01878: specified field not found in datetime or interval

You can run the below queries to find out when the job was scheduled to run and who owns the job

Connect to the database with the priv_user from the above query for that particular job and change the next_date manually by running the following

NOTE: If possible move the time of the job to away from 2 AM time, that is when the time change happens twice every year. I did moved the job to 04:00 AM so you are good for the future as well.


No comments: