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;