APEX Email related tables/view/jobs

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

APEX Email related tables/view/jobs

Post by admin »

select * from APEX_200100.wwv_flow_mail_queue
select * form apex_mail_queue
select * from FROM ALL_SCHEDULER_JOB_LOG
select * from DBA_SCHEDULER_JOB_RUN_DETAILS where JOB_NAME='ORACLE_APEX_MAIL_QUEUE';
select * from all_scheduler_jobs where job_name like 'ORACLE_APEX_MAIL_QUEUE'
select * from all_scheduler_running_jobs;

-- In case your email stuck in queue then here is the way to restart job and check if all emails sent.

BEGIN
SYS.DBMS_SCHEDULER.STOP_JOB
(job_name => 'APEX_200100.ORACLE_APEX_MAIL_QUEUE' ,force => TRUE);
END;

BEGIN
DBMS_SCHEDULER.ENABLE ('APEX_200100.ORACLE_APEX_MAIL_QUEUE');
END;

begin
SYS.DBMS_SCHEDULER.RUN_JOB
(job_name => 'APEX_200100.ORACLE_APEX_MAIL_QUEUE'
,use_current_session => FALSE);
END;
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest