A.1 List of DBMS_SCHEDULER Jobs

Table A-1 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

ORACLE_APEX_PURGE_SESSIONS

Purges sessions older than 12 hours (the default). This job runs every hour.

See Also: "Managing Session State for an Instance"

ORACLE_APEX_MAIL_QUEUE

Sends mail that is in the mail queue every 5 minutes.

See Also: "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 Also: "About Websheet Applications" in Oracle Application Express Application 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 Also: "Purging Inactive Workspaces"