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 Application Express.

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_PURGE_SESSIONS`	Purges sessions older than 12 hours (the default). This job runs every hour.	See "Managing Session State for an Instance"
`ORACLE_APEX_MAIL_QUEUE`	Sends mail that is in the mail queue every 5 minutes.	See "APEX_MAIL" in Oracle Application Express API Reference and "Configuring Email"
`ORACLE_APEX_WS_NOTIFICATIONS`	Determines Websheet notifications that must be sent every 30 minutes.	See "About Websheet Applications" in Oracle Application Express App Builder User’s Guide
`ORACLE_APEX_DAILY_MAINTENANCE`	Performs nightly maintenance, every day at 0100. This job archives the activity summary and runs the workspace purge process.	See"Purging Inactive Workspaces"

Parent topic: DBMS_SCHEDULER Jobs