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.

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_PURGE_SESSIONS	Purges sessions older than 12 hours (the default). This job runs every hour.	See "Managing Session State for an Instance"
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 Application Express Administration Services under Monitor Activity, Developer Activity, Data Loading Jobs.	See "Monitoring Activity Across a Development Instance" and "Using Data Workshop" in Oracle Application Express SQL Workshop Guide
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"