ORACLE_APEX_MAIL_QUEUE Job Is Not Sending Mail To Users In RAC Environment And the DBA_SCHEDULER_JOBS Shows the Job Is Disabled Even After Enabling It (Doc ID 2590989.1)

Last updated on AUGUST 05, 2022

Applies to:

Symptoms

ORACLE_APEX_MAIL_QUEUE is not sending mail to users; no errors.

APEX 18.1 installed in Database ("RAC") 12.2.
APEX was installed a year ago. Didn't have any problems with emails.

Encountered a problem with the ORACLE_APEX_MAIL_QUEUE job, it was broken. Dropped the job and recreated it per --> Outbound Email Delivery From APEX Seems To Stall (Stuck) (Doc ID 2057872.1)
But the mail is not getting delivered and apex_mail_queue table shows messages in the queue.

The mail can be sent manually using utl_smtp package.

NOTE:
The DBA_SCHEDULER_JOBS shows that the ORACLE_APEX_MAIL_QUEUE is Not Enabled (ENABLED -> FALSE).

The query
select owner,job_name, enabled from DBA_SCHEDULER_JOBS WHERE job_name ='ORACLE_APEX_MAIL_QUEUE';
result:

OWNER JOB_NAME ENABL

APEX_180100 ORACLE_APEX_MAIL_QUEUE FALSE

run
exec dbms_scheduler.enable('ORACLE_APEX_MAIL_QUEUE');
and run query again

select owner,job_name, enabled from DBA_SCHEDULER_JOBS WHERE job_name ='ORACLE_APEX_MAIL_QUEUE';
result still the same:

OWNER JOB_NAME ENABL

APEX_180100 ORACLE_APEX_MAIL_QUEUE FALSE

--> The job is not getting enabled.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.