Batch Job Scheduling
Using Oracle DBMS Scheduler
The Oracle DBMS Scheduler is provided with Oracle Utilities cloud services and is the default job scheduling option.
Refer to Batch Scheduler Integration in the Administrative User Guide or the online help for more information.
However, note that access to the DBMS Scheduler via SQL using SQL Developer is not allowed in the cloud.
The Oracle Utilities Application Framework provides various REST services to directly interact with the DBMS scheduler. While batch operations use the underlying services of these APIs to interact with the DBMS scheduler, there are certain restrictions in calling the REST services from outside the system or via a third party integration. Please review the Batch Scheduler Integration for Oracle Utilities Application Framework technical reference paper in Oracle Support (Document ID 2196486.1) for more information.
A copy of the batch job stream definitions created in batch operations is kept in the Oracle Utilities Application Framework along with publishing them to DBMS scheduler. Any changes to such batch job stream definitions such as step changes, schedule changes, and so on must be done through the batch operations user interface. The Oracle Utilities Application Framework REST services should not be used directly for changing the definitions as this can cause the Oracle Utilities Application Framework job stream definitions go out of sync with the definitions inside the DBMS scheduler. This can result in a risk of losing historical data tracking, logging, risk of losing definitions and re-work etc. It is advised that only those Oracle Utilities Application Framework DBMS Scheduler REST services that pertain to handling job stream runs, not definitions be used from outside of the system or via third party integrations. Such services involve querying on the job stream run status, details, make adhoc submissions of the job stream run, canceling a job stream run and getting past job stream runs.
Cloud customers can use a set of REST APIs to set up and manage their batch scheduling using the Oracle DBMS Scheduler. The available DBMS scheduler APIs can be viewed by searching for Business Services that start with F1-DBMS.
Partial DBMS Updates
Partial updates to the Database Management Schedule (DBMS) chain are not allowed.
Pausing DBMS Jobs
Holding the execution of DBMS jobs is currently not supported.
Scheduling Batch Jobs
Scheduling a batch job to be effective in future is currently not supported.