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 describesDBMS_SCHEDULER
jobs that are created in the database when you install Oracle Application Express.
A.1 List of DBMS_SCHEDULER Jobs
The following table describes DBMS_SCHEDULER
jobs that are created in the database when you install Oracle Application Express.
Table A-1 DBMS_SCHEDULER Jobs
Job Name | Description | To Learn More |
---|---|---|
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" |
|
This job runs nightly at 0100 to gather statistics and data analysis of all workspace schema tables and caches into the Oracle Application Express 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. |
|
|
Performs nightly maintenance, every day at 0100. This job archives the activity summary and runs the workspace purge process. |
|
|
SQl Workshop data loading processes spawn jobs named
While the jobs are running, you can view them in Oracle Application Express 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 |
|
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 |
|
Sends mail that is in the mail queue every 5 minutes. |
See "APEX_MAIL" in Oracle APEX API Referenceand "Configuring Email" |
|
Purges sessions older than 12 hours (the default). This job runs every hour. |
|
|
Sends interactive report subscription that is in the queue every 30 minutes. |
n/a |
Parent topic: DBMS_SCHEDULER Jobs