wf_notifications mail_status failed

wf_notifications mail_status failed

 

Notification mailer is uses to send Email Notifications to the User. We see the Workflow Notifications in the Table wf_notification. If you want to check whether the Workflow Notification Mailer , has sent the Email notification or not , then you can take the help of this Table wf_notification. Column Mail_Status in the wf_notification shows the Email status of the Notification. if Mail_Status showing 'Failed' Then it means , Workflow Notification mailer has picked this record to send Email but to some issue , Mailer failed to send email to the user. There could be many reason of this Failed status like if there is no email address set for the recipient or workflow local roles are not set for the user or it could be the issue of user preferences issue.

This is the SQL Query to find the Failed Records of the Workflow Notification Mailer.

Select * from Wf_Notifcations
Where Mail_Status='Failed'.