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:
Post a Comment