My Oracle Support Banner

Known Issues And Bugs Using the Scheduler (Doc ID 1311355.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 to 11.2.0.3 [Release 9.0.1 to 11.2]
Information in this document applies to any platform.

Purpose

The purpose of this document is to assist with issues using the Oracle Scheduler system.
With the usage of the Oracle Scheduler system, a very flexible application specific environment can arise, which makes it difficult to analyze unexpected behaviour.
Therefore, it is important to break down the issue into the different aspects for a detailed analysis, to finally find the cause of an unexpected behaviour.
There are many notes for problems with the Scheduler system, however, it is not always easy to find an immediate solution. This guide is an attempt to list some tips and tricks, relevant notes, known bugs and issues related to Scheduler usage and try to provide the first steps for analyzing, and listing the relevant notes dependent on the database version and specific scheduler part.

NOTE:
Any feedback and comments are greatly appreciated. This note will be continually reviewed and updated, adding new tricks, notes, bugs and additional information in an attempt to keep it up to date.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 --- Symptoms ---
 1. Generic Issues setting up Scheduler Jobs and the Job Definition
 Suggestions:
 2. Scheduled Job doesn't run automatically or using run_job
 Known Notes and Bugs:
 Suggestions:
 3. Scheduled Job doesn't run automatically, but a manual run will succeed
 Known Notes and Bugs:
 4. Hanging Jobs cannot be stopped or dropped
 Known Notes and Bugs:
 5. DST issues: Scheduled Jobs don't run after a clock change
 For more information refer to:
 Known bugs:
 6. Issues related to the Job Log Scheduler views
 Suggestions:
 Known Notes and Bugs:
 7. External Job Issues
 Suggestions for UNIX Platforms:
 Suggestions for Windows Platforms:
 For more information refer to:
 Known Bugs:
 8. Version 11G: Remote External Jobs and the Scheduler Agent
 Known Notes and Bugs:
 9. Event based Job Issues
 Known Bugs:
 10. Chained Job Issues
 Known Notes and Bugs:
 11. Scheduler Job Notifications Failure
 Known Notes and Bugs:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.