Scripts for Workflow notification mailer

Scripts for Workflow notification mailer 

Workflow: To see failed, open notifications
===============================================
SELECT message_type, COUNT(1)
FROM apps.wf_notifications
WHERE 1 = 1 AND mail_status = 'FAILED' AND status = 'OPEN'
GROUP BY message_type;

Check pending e-mail notification that was pending for process.

Sql> SELECT COUNT(*), message_name FROM wf_notifications

WHERE STATUS='OPEN'

AND mail_status = 'MAIL'

GROUP BY message_name;

Sql> SELECT * FROM wf_notifications

WHERE STATUS='OPEN'

AND mail_status = 'SENT'

ORDER BY begin_date DESC

You are welcome to leave a comment....