Previous Next JavaScript must be enabled to correctly display this content

## A DBMS_SCHEDULER Jobs

The `DBMS_SCHEDULER` package provides a collection of scheduling functions and procedures that can be called from any PL/SQL program.

- List of DBMS_SCHEDULER Jobs
  The following table describes `DBMS_SCHEDULER` jobs that are created in the database when you install Oracle APEX.

### A.1 List of DBMS_SCHEDULER Jobs

The following table describes `DBMS_SCHEDULER` jobs that are created in the database when you install Oracle APEX.

Job Name | Description | To Learn More
--- | --- | ---
`ORACLE_APEX_AUTOMATIONS` | Executes due automations every 2 minutes. | See Managing Automations in Oracle APEX App Builder User’s Guide
`ORACLE_APEX_BACKUP` | Performs backups of applications that have been modified. Purges backups according to limit defined by the "Number of backups per application" instance setting. The backup job will be disabled when the setting is zero (0). The backup job runs every day starting at 0200. | See Configuring the Number of Application Backups
`ORACLE_APEX_BG_PROCESSES` | Kicks off background page process executions. Runs every 2 minutes for a duration of 1 minute and about 57 seconds | See Understanding Background Page Processing in Oracle APEX App Builder User’s Guide
`ORACLE_APEX_DICTIONARY_CACHE` | This job runs nightly at 0100 to gather statistics and data analysis of all workspace schema tables and caches into the Oracle APEX Data Dictionary. If the Data Dictionary Cache is incorrect or out of date, you can update Data Dictionary Cache manually from the Workspace Cache report. | See Viewing or Refreshing the Data Dictionary Cache
`ORACLE_APEX_DAILY_METRICS` | Performs nightly maintenance, every day at 0100. This job archives the activity summary and runs the workspace purge process. | n/a
`ORACLE_APEX_DAILY_MAINTENANCE` | This job inserts the overall metrics at instance, workspace and schema level on a daily basis. Runs every day at 02:00 AM. | See Purging Inactive Workspaces in Oracle APEX App Builder User’s Guide
`ORACLE_APEX_DTLD${job-id}` | SQl Workshop data loading processes spawn jobs named `ORACLE_APEX_DTLD${job-id}`. Jobs are purged after completion. While the jobs are running, you can view them in Oracle APEX Administration Services under Monitor Activity, Developer Activity, Data Loading Jobs. | See Monitoring Activity Across an Instance and Using Data Workshop in Oracle APEX SQL Workshop Guide
`ORACLE_APEX_ISSUE_EMAILS` | Determines Team Development notifications that must be sent. This job runs every hour. | See Configuring the Number of Application Backups in Oracle APEX App Builder User’s Guide
`ORACLE_APEX_MAIL_QUEUE` | Sends mail that is in the mail queue every 5 minutes. | See APEX_MAIL in Oracle APEX API Referenceand Configuring Email
`ORACLE_APEX_PURGE_SESSIONS` | Purges sessions older than 12 hours (the default). This job runs every hour. | See Managing Session State for an Instance
`ORACLE_APEX_PWA_PUSH_QUEUE` | Sends Push Notifications every 2 minutes. | See Creating a Progressive Web App (PWA) in Oracle APEX App Builder User’s Guide
`ORACLE_APEX_REST_SOURCE_SYNC` | Executes due REST Source Synchronizations every 10 minutes. | See Managing Data Synchronization in Oracle APEX App Builder User’s Guide
`ORACLE_APEX_TASKS_EXPIRE` | Expires any task in the task instance table that is past the due date with an expiration policy set to Expire or Renew. Creates a new task for any task set to Renew, as long as the maximum number of renewals is not exceeded. Executes any Before Expire or Expire actions. This job runs hourly. | See Creating a Task Definition in Oracle APEX App Builder User’s Guide.
`ORACLE_APEX_TASKS_PURGE` | Purges completed tasks with a retention period that is less than or equal to the current date. Purges errored, expired, and canceled tasks. Saves the purged task details as a JSON document. This job runs nightly at 0200 hours. | See About Task Retention and Task Purging in Oracle APEX App Builder User’s Guide and Configuring Workflow Settings.
`ORACLE_APEX_WFS_PURGE` | Purges completed workflows with a retention period that is less than or equal to the current date. Purges terminated workflows. This job runs nightly at 0300 hours. | See Workflow Instance Retention in Oracle APEX App Builder User’s Guide.
`ORACLE_APEX_WF_TIMEOUT` | Runs every 5 minutes to check for workflow activites for which the specified due date has elapsed, and performs timeout-handling for these activities. | See Defining Activity Timeout in Oracle APEX App Builder User’s Guide.
`ORACLE_APEX_WS_NOTIFICATIONS` | Sends interactive report subscription that is in the queue every 30 minutes. | n/a

Parent topic: DBMS_SCHEDULER Jobs