Overview

The DBMS_SCHEDULER package manages scheduled jobs. The package provides a group of functions and procedures that you can call by using a procedural language (PL) program.

Privileges

You must directly grant the object privileges of the DBMS_SCHEDULER package to a user. If you grant privileges on scheduler objects such as jobs by using roles, the privileges cannot be recognized.

Only SYS users can perform operations on objects in SYS schemas.

Considerations

Some procedures in the DBMS_SCHEDULER package support a list of object names separated with commas (,). If an object in the specified list returns an error during execution, the Scheduler stops executing the object and does not perform the required tasks for subsequent objects in the list.

During the execution of the DBMS_SCHEDULER package, a PL exception is returned if an object does not exist.

The Scheduler uses versatile calendar syntax to help you define recurring schedules, such as a task that runs at 4:00 p.m. every Tuesday and Friday or on the second Wednesday of every month. The calendar syntax is used in the repeat_interval parameter in the calendar expressions of many package subprograms. The calculation of a calendar expression produces a set of discrete timestamps.

Subprograms

The following table describes the DBMS_SCHEDULER subprograms supported by the current OceanBase Database version.