The DBMS_SCHEDULER
package provides a collection of scheduling functions and procedures that can be called from any PL/SQL program.
DBMS_SCHEDULER
jobs that are created in the database when you install Oracle Application Express.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 |
---|---|---|
|
Purges sessions older than 12 hours (the default). This job runs every hour. |
|
|
Sends mail that is in the mail queue every 5 minutes. |
See "APEX_MAIL" in Oracle Application Express API Reference and "Configuring Email" |
|
Determines Websheet notifications that must be sent every 30 minutes. |
See "About Websheet Applications" in Oracle Application Express App Builder User’s Guide |
|
Performs nightly maintenance, every day at 0100. This job archives the activity summary and runs the workspace purge process. |