ORA-01839: date not valid for month specified
Hi there,
I'm not sure if this is the right place for this posting .... but I got the following errors in my alert log file (10.2.0.1)
Errors in file ..../bdump/xxx_j000_23928.trc
ORA-12012: error on auto execute of job 8888
ORA-01839: date not valid for month specified
in the trace file:
*** ACTION NAME: (AUTO_SPACE_ADVISORY_JOB) 2009-03-30 22:00:02.313
*** MODULE NAME: (DBMS_SCHEDULER) 2009-03-30 22:00:02.313
*** SERVICE NAME: (SYS$USERS) 2009-03-30 22:00:02.313
*** SESSION ID: (194.87) 2009-03-30 22:00:02.313
*** 2009-03-30 22:00:02.313
ORA-12012: error on auto execute of job 8888
ORA-01839: date not valid for month specified
The problem is the date is not valid for month specified, my question is how do I go fix this problem. This is a newly created db.
I only have 2 jobs (select job from dba_jobs) and there is no 8888.
The 2 jobs I have are:
JOB INTERVAL WHAT
1 sysdate+1/240 unlock;
2 trunc(sysdate) + 7 + 3/24 dbms_stats.gather_schema_stats('db_name');
Please assist. Thanks.
Edited by: user10427867 on Mar 31, 2009 12:00 PM