Hello,
I hope you can help me, as I am stuck with this problem:
I have a DBMS_SCHEDULER - Job wich is scheduled 06:00 am every day. When I select from DBA_SCHEDULER_JOBS, I see the state is "scheduled", failure_count is 0, max_failures is 1, raise_events are "JOB_BROKEN,JOB_STOPPED,JOB_DISABLED".
There is a notification for this job triggered by the events JOB_BROKEN, JOB_STOPPED and JOB_DISABLED.
Now, every day I receive a notification like this:
Job: SYSZSK.JOB_DELETE_ZSK_PROTOKOLL
Event: JOB_BROKEN
Date: 07-JAN-14 06.00.00.046633 AM +02:00 Log id: 69808
Job class: JCL_FBI_NV Run count: 1 Failure count: 1 Retry count: 0 Error code:0 Error message:
BUT:
- I can´t find a row in DBA_SCHEDULER_JOB_LOG with LOG_ID = 69808
- I do find a log for the job:
LOG_ID: 282810
LOG_DATE: 07-JAN-2014 05:00:01,033737 +01:00
OWNER: SYSZSK
JOB_NAME: JOB_DELETE_ZSK_PROTOKOLL
OPERATION: RUN
STATUS: SUCCEEDED
Can you give me a hint what´s going on here? Any help highly appreciated...
Best regards,
Gerd