最近某库有job 出错的日志:
2016-04-26 04:30:01ORA-12012error on auto execute of job 48330snsora1_j001_42392.trc
ORA-06576not a valid function or procedure name
2016-04-27 01:00:00ORA-12012error on auto execute of job 31224snsora1_j002_5010.trc
可是在dba_jobs 中根本找不到 48330 的job,查看对应的trc 文件:
*** 2016-04-26 04:30:01.255
*** SESSION ID:(1484.18684) 2016-04-26 04:30:01.255
*** CLIENT ID:() 2016-04-26 04:30:01.255
*** SERVICE NAME:(SYS$USERS) 2016-04-26 04:30:01.255
*** MODULE NAME:(DBMS_SCHEDULER) 2016-04-26 04:30:01.255
*** ACTION NAME:(JOB_INSERT_MBLOG_SHARE) 2016-04-26 04:30:01.255 其中ACTION NAME:(JOB_INSERT_MBLOG_SHARE) 对应 dba_scheduler_jobs 中 job_name ,这样就找到了对应的job