Oracle job执行失败，retry的次数

check_mk告警， 记录有job执行失败，使用如下sql去复核，没有job执行失败
select * from dba_jobs where failures<>0

我猜应该是开始执行失败，后面retry成功，但是前面执行失败的时候刚好被check_mk抓到，才会有告警出现
DBMS_JOB第一次执行失败，他会1分钟后retry,假如retry失败，它会2分钟后第2次retry,第3次是4分钟后，以此类推，每一次都会等候前次2倍间隔时间去rerty,直到16次才会终止retry
If your procedure generates any sort of error, DBmS_JOB will re-submit the job, and keep trying for up to 16 times:
From MetaLink Note:103349.1
If a job returns an error while Oracle is attempting to execute it, Oracle tries to execute it again. The first attempt is made after one minute, the second attempt after two minutes, the third after four minutes, and so on, with the interval doubling between each attempt. If the job fails 16 times,Oracle automatically marks the job as broken and no longer tries to execute it.
However, between attempts, you have the opportunity to correct the problem that is preventing the job from running. This will not disturb the retry cycle, and Oracle will eventually attempt to run the job again.