Trigger email when Milestone is completed RRS feed

  • Question

  • Hi,

    I'm new to Project Server (2010). Need help for my requirement. When a milestone gets completed, need to send email. Though I searched similar threads, I didn't get concrete solution.
    My question is, how do I capture "Milestone completed" in the event? Or can I use SQL Trigger on Reporting Database? Is it supported?

    Thursday, July 11, 2013 12:26 PM

All replies

  • The best way I can think of is using a workflow attached to the EPT. Within the workflow, add a while condition to read the 'Milestone Completed" field using the PSI, check it's value, and proceed if it is true.

    Fair chunk of programming involved for a newbie...

    Wednesday, July 17, 2013 3:32 PM