Hi I've strange job errors on my Oracle 8i instance.
ORA-12012: error on auto execute of job 959 (number may differ)
ORA-23421: job number 959 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 525
ORA-06512: at "SYS.DBMS_IJOB", line 258
ORA-06512: at line 1
Why It is strange? Because there are no such jobs in jobs list. Look at this:
SQL> select job, log_user, broken, what, failures from sys.dba_jobs;
JOB LOG_USER BROKE WHAT FAILURES
---------- -------- ----- ------------------------------------------------------- ----------
802 ASKUEANA N RepConfig.runBatchReport(784,job,next_date); 0
LYZER
753 ASKUEANA N RepConfig.runBatchReport(780,job,next_date); 0
LYZER
754 ASKUEANA N RepConfig.runBatchReport(776,job,next_date); 0
LYZER
755 ASKUEANA N RepConfig.runBatchReport(627,job,next_date); 0
LYZER
JOB LOG_USER BROKE WHAT FAILURES
---------- -------- ----- ------------------------------------------------------- ----------
756 ASKUEANA N RepConfig.runBatchReport(632,job,next_date); 0
LYZER
757 ASKUEANA N RepConfig.runBatchReport(781,job,next_date); 0
LYZER
759 ASKUEANA N RepConfig.runBatchReport(738,job,next_date); 0
LYZER
760 ASKUEANA N RepConfig.runBatchReport(739,job,next_date); 0
JOB LOG_USER BROKE WHAT FAILURES
---------- -------- ----- ------------------------------------------------------- ----------
LYZER
761 ASKUEANA N RepConfig.runBatchReport(754,job,next_date); 0
LYZER
782 ASKUEANA N archiving.replaceparvaluetoar; 0
LYZER
10 rows selected.
SQL> show parameter job
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
job_queue_interval integer 60
job_queue_processes integer 10
SQL> show err
No errors.
As you can see there is no such jobs! How that could happen? And how should I correct that? Is there any scripts that could check database if it is in correct state ot not?