Improving performance of Notification Mailer
I have few doubts regarding notification mailer.
1) Does MAIL_STATUS column consider the validity of the user email ID OR it just considers posting an email to the SMTP server from the WF_NOTIFICATION_OUT.
This is what I found on the net , the implication of STATUS and MAIL_STATUS column in wf_notifications.
OPEN / SENT: Notification Mailer posted the email to the SMTP Server .
OPEN / FAILED: Notification Mailer failed to deliver the email .
CLOSED / SENT: Notification Mailer sent the email , and then notification has been closed.
This means, even if the user has wrong email ID but if the notification mailer posts the email to the SMTP successfully , then the MAIL_STATUS would be SENT irrespective of the fact that mail is received by the user or not where as if notification mailer unable to post the email to the SMTP , then and then only the MAIL_STATUS column would be FAILED.