APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Restart ORACLE_APEX_MAIL_QUEUE and ORACLE_APEX_ISSUE_EMAILS job in Autonomous

Anderson FerreiraJul 14 2020 — edited Jul 14 2020

Hi,

APEX is not sending the emails!

The problem started when my Free Autonomous account expired. I upgraded to paid version but the problem remains.

I have my ORACLE_APEX_MAIL_QUEUE and ORACLE_APEX_ISSUE_EMAILS jobs with NEXT_RUN_DATE in the past.

How can I restart the jobs in Autonomous database?

It is a shared Database, APEX version 20.1.

I tryed in Web SQL Developer the following command, but I do not have the privileges as ADMIN user.

begin

dbms_scheduler.run_job('apex_200100.ORACLE_APEX_MAIL_QUEUE') ;

dbms_scheduler.run_job('apex_200100.ORACLE_APEX_ISSUE_EMAILS') ;

end;

Thanks in advance

Added on Jul 14 2020

#apex-discussions

6 comments

2,434 views