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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Send notification email when timesheet is rejected 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Level resource allocation error 1
Send customize notifications in Project Server 2007- 1
Custom Notification 0
MS Project Overwrites Max. Resource hrs 0
Email Notification Mods 0

Top