Custom Notifications in Project Server

J

James

Hi,

Is there any way to set up a custom notification in Project Server that
sends an email alert when a task in a project plan changes status (i.e.
falls behind schedule)?

If not, how could this be done through VBA?

Regards

ames
 
E

Ed Morrison

You can create a SQL Insert/Update trigger on either the msp_tasks or
msp_view_proj_tasks_std (or any other table that meets your needs). Use the
xp_sendmail procedure. Note: To use xp_sendmail, SQL Mail must be set up.
 
Top