如何诊断job执行失败

1. 看job有没有机会执行

确保init.ora中job_queue_processes参数是否被设为>0的值.

show parameter job_queue_processes

2. 看是否执行job出错.

查看alert.log获取出错信息.

3. 看是否job所调用的procedure/package出错.

这个需要你自己在procedure/package中自己书写记录错误日志的代码.

4. 经常查看你的DBA_JOBS看看，相应的job是不是broken了，

BROKEN： Y: no attempt is made to run this job

N: an attempt is made to run this job

A job can be broken in two ways:

Oracle has failed to successfully execute the job after sixteen attempts. The job has been explicitly marked as broken by using the procedure DBMS_ JOB.BROKEN.

在尝试（默认）16次后还是不能成功执行，该job会被oracle自动标记为broken=y

或者你可以手动运行看看，有什么错误提示。

EXECUTE DBMS_JOB.RUN(JOB_ID);