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:
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:
- I can´t find a row in DBA_SCHEDULER_JOB_LOG with LOG_ID = 69808
- I do find a log for the job:
LOG_DATE: 07-JAN-2014 05:00:01,033737 +01:00
Can you give me a hint what´s going on here? Any help highly appreciated...
Can you please check the following:
SQL> select EVENT FROM DBA_SCHEDULER_NOTIFICATIONS WHERE JOB_NAME='JOB_DELETE_ZSK_PROTOKOLL' AND OWNER='SYSZSK';
SQL> select JOB_ACTION,START_DATE,REPEAT_INTERVAL,ENABLED,JOB_CLASS, RUN_COUNT,LAST_START_DATE,LAST_RUN_DURATION,NEXT_RUN_DATE from dba_scheduler_jobs where JOB_NAME='JOB_DELETE_ZSK_PROTOKOLL' AND OWNER='SYSZSK';
SQL> select LOG_ID, LOG_DATE, STATUS, REQ_START_DATE, ACTUAL_START_DATE, RUN_DURATION, from DBA_SCHEDULER_JOB_RUN_DETAILS where JOB_NAME='JOB_DELETE_ZSK_PROTOKOLL' AND OWNER='SYSZSK';