_SCHEDULER_JOB_RUN_DETAILS view and CHAIN_STALLED question
818464Jan 7 2011 — edited Jan 14 2011Hi All,
We are testing Oracle Scheduler (on Oracle 11.2.0.1.0) for our daily materialized views refresh process. We have created the required programs, schedules, chains and jobs. All seems to be working fine except 2 issues that we have started to see recently. Any feedback/solution regarding these issues would be a great help.
1. A couple of chains are showing up in "CHAIN_STALLED" state. Oracle documentation says a manual intervention is required. How do we change the state of the chain from "CHAIN_STALLED" to "SCHEDULED"?
2. Some of the jobs are running but the run log does not show up in SCHEDULERJOB_RUN_DETAILS view. We can see the job run details in SCHEDULERJOBS view (the LAST_START_DATE, LAST_RUN_DURATION & NEXT_RUN_DATE are getting updated daily reflecting the daily run details). What could be causing the job run details not to show up in SCHEDULERJOB_RUN_DETAILS view? All these jobs have the following definitions
SCHEDULE_TYPE => 'CALENDAR'
ENABLED => TRUE
AUTO_DROP => TRUE
RESTARTABLE => TRUE
STATE => 'SCHEDULED'
JOB_PRIORITY => 3
LOGGING_LEVEL => 'OFF'
FYI, if you think the reason could be LOGGING_LEVEL set to 'OFF', then the other jobs with LOGGING_LEVEL = 'OFF' are showing up in SCHEDULERJOB_RUN_DETAILS view. Also these jobs run at different times during the night (0030 hrs, 0330 hrs, 0430 hrs, 0630 hrs & 0800 hrs). But the job chains running during these times are running without any issues.
Thanks to all in advance
DOM