Action Items Overdue Stalker – SQL

This Process sends an email to every Action Item Assignee where the Due Date/Time has passed and the Status is either Open, or In Progress.  Users may want to modify this stalker to include Status = Deferred.  In addition, the Resource Manager for the Assignee receives a copy of the email.

In order to generate emails, the SMTP gateway must be up and running and Resources must have a valid email address.