Overview of DBMS_JOB

The DBMS_JOB package is used to schedule and manage jobs in the job queue.

Privilege requirements for DBMS_JOB

You do not need any specific system privileges to use and manage DBMS_JOB. Only the job owner or a user granted the DBA privilege can modify or delete a job.

Considerations for using DBMS_JOB

DBMS_JOB supports multi-zone execution of jobs. By default, a job can be executed in any zone, but only one zone can be selected. You can bind a job to a specific zone by specifying the zone name.

The following describes the execution process for creating, modifying, or running a job associated with a zone. If no zone is specified, the job can be executed in any zone.

1. Call the DBMS_JOB.SUBMIT procedure to submit the job to the job queue.

2. Call the DBMS_JOB.ZONE procedure to assign the specified zone for the job.

3. Call the DBMS_JOB.CHANGE procedure to modify the user-defined parameters associated with the job.

4. Call the DBMS_JOB.RUN procedure to run the job.

5. Stop the job.

Overview of DBMS_JOB subprograms

The following table describes the subprograms supported by OceanBase Database in the current version and their descriptions.