Viewing APEX Mail Log & Queue

Run below query in SQL Workshop 

SELECT * FROM apex_mail_log ORDER BY last_updated_on DESC;

Above said query, used to find the apex mail log.

This query will find the mails in apex mail queue.

SELECT * FROM apex_mail_queue ORDER BY last_updated_on DESC;

We can push apex mail by apex_mail.push_queue

exec apex_mail.push_queue;

OR

BEGIN
  apex_mail.push_queue (p_smtp_hostname => 'IP_ADDRESS', 
                                         p_smtp_portno      => 'PORT_NUMBER'
                                        );
END;

Comments

Post a Comment

Popular posts from this blog

Highlight the cell of Interactive Report based on Search Criteria in Oracle APEX

Querying Data From Flat Files in Oracle

Number of Tables by The Number of Rows in Oracle Database

Save Selected Interactive Grid Records into a Collection - Oracle APEX

Highlight Data That Meet Certain Criteria in Oracle APEX Report

Return a Validation Message using JavaScript if the Oracle Application Express Item is Empty

Remove X (Close Mark) from Oracle APEX Modal Dialog

Display User Rating Icons Dynamically in Oracle APEX Report

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Find Where Specific Table or View is Used in Oracle Database