none
Email Alerts for Deadlines Project 2013 RRS feed

  • Question

  • Is there a way to have Project 2013 send email alerts for deadlines?  I'm told earlier versions of Project had this feature but I need it to work with 2013.

    Any help would be appreciated.  

    Thanks!

    Friday, January 3, 2014 7:47 PM

Answers

  • Hello,

    The easiest solution for this if you are using Project Server 2013 would be an SSRS report with a data driven email subscription. Get the email to send only if there is data (i.e. task that have missed the deadline or deadline in a given time frame). Some example queries for the report are below:

    missed deadline:

    select		P.ProjectName
    		,	P.ProjectOwnerName
    		,	T.TaskName
    		,	T.TaskFinishDate
    		,	T.TaskDeadline
    
    from		MSP_EpmTask_UserView T
    INNER JOIN	MSP_EpmProject_UserView	P
    ON			P.ProjectUID = T.ProjectUID
    where		T.TaskDeadline is not null
    			and T.TaskDeadline < T.TaskFinishDate

    Deadline within a week:

    select		P.ProjectName
    		,	P.ProjectOwnerName
    		,	T.TaskName
    		,	T.TaskFinishDate
    		,	T.TaskDeadline
    
    from		MSP_EpmTask_UserView T
    INNER JOIN	MSP_EpmProject_UserView	P
    ON			P.ProjectUID = T.ProjectUID
    where		T.TaskDeadline is not null
    			and T.TaskDeadline Between GETDATE() and GETDATE()+7
    Paul

    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Sunday, January 5, 2014 3:37 PM
    Moderator

All replies

  • jmcmillen2 --

    Whomever told you this feature was available in previous versions of Project Server is mistaken.  There was no way to set up e-mail alerts for Deadlines in any previous version of Project Server, nor is this available in the 2013 version.  The only way I can imagine you could make this happen would be to write custom software code, such as in the VBA programming language, or in PSI.  If you want to explore that avenue, I would recommend you post this as a new question in the Project Customization and Programming user forum at:

    http://social.technet.microsoft.com/Forums/projectserver/en-US/home?forum=project2010custprog&filter=alltypes&sort=lastpostdesc

    This way our software developer friends could have a chance to examine your need and to determine whether it is even possible.  Hope this helps.


    Dale A. Howard [MVP]

    Friday, January 3, 2014 8:59 PM
    Moderator
  • Hello jmcmillen2

    I think a simpler solution would be to create a SQL query that finds the past deadlines in your project server and then use something like SSIS (Sql Server Integrated Solutions) to run a schedule where it can find those missed deadline and send an email to the project manager.

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Sunday, January 5, 2014 4:45 AM
    Moderator
  • Hello,

    The easiest solution for this if you are using Project Server 2013 would be an SSRS report with a data driven email subscription. Get the email to send only if there is data (i.e. task that have missed the deadline or deadline in a given time frame). Some example queries for the report are below:

    missed deadline:

    select		P.ProjectName
    		,	P.ProjectOwnerName
    		,	T.TaskName
    		,	T.TaskFinishDate
    		,	T.TaskDeadline
    
    from		MSP_EpmTask_UserView T
    INNER JOIN	MSP_EpmProject_UserView	P
    ON			P.ProjectUID = T.ProjectUID
    where		T.TaskDeadline is not null
    			and T.TaskDeadline < T.TaskFinishDate

    Deadline within a week:

    select		P.ProjectName
    		,	P.ProjectOwnerName
    		,	T.TaskName
    		,	T.TaskFinishDate
    		,	T.TaskDeadline
    
    from		MSP_EpmTask_UserView T
    INNER JOIN	MSP_EpmProject_UserView	P
    ON			P.ProjectUID = T.ProjectUID
    where		T.TaskDeadline is not null
    			and T.TaskDeadline Between GETDATE() and GETDATE()+7
    Paul

    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Sunday, January 5, 2014 3:37 PM
    Moderator
  • Hello Paul,

    Excellent solution!

    Wharton


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Monday, January 6, 2014 12:14 AM
    Moderator