locked
Project Server : Resource Manager Email Notification RRS feed

  • Question

  • Hi Team,

    In our environment when ever a resource submits the timesheet to resource manager, the Project Server is not sending an alert to Resource Manager about the submission.

    Can any one please provide me the steps to enable the alerts to Resource Manager on a timesheet submission?

    Thanks in advance.


    Ravishankar
    Friday, October 14, 2011 12:57 PM

Answers

  • Hi,

    Just to update this thread, i have written my custom programming to send alerts to TM and Resource when a timesheet is submitted as well approved/rejected by TM.

     

    Thanks


    Ravishankar Polepalli (MCP)
    Microsoft Dynamics, Project Server and SharePoint Server Consultant
    ravi.polepalli@gmail.com
    Monday, December 26, 2011 12:28 PM

All replies

  • In the server settings for PWA, go to the "Alerts and Reminders" and make sure the SMTP server has been defined.  Also ping it to make sure it can be access.

    cheers


    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA
    www.WhartonComputer.com
    Friday, October 14, 2011 9:34 PM
  • Hi

    Alerts have been configured already, and PS is sending all emails excluding Resource Manager alerts.

    Is there any thing else i am missing here.

    Ravishankar


    Ravishankar
    Saturday, October 15, 2011 4:29 AM
  • Ravishankar --

    Unless I am forgetting something major, I do not believe that the Project Server 2010 sends e-mails to resource managers when their resources submit Timesheets.  I believe the system sends e-mails only to project managers when their team members submit task updates from the Tasks page in PWA.  If I am wrong, friends in this public forum, please feel free to correct me. Thanks


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Saturday, October 15, 2011 9:13 PM
  • Team,

    Is there any work around (or) solution to get email alerts for Resource Managers? Please suggest...

    Thanks

    Ravishankar


    Ravishankar
    Monday, October 17, 2011 11:18 AM
  • Ravishankar --

    The only way to do this would require custom software development.  For help in that area, you might want to post your question as a "how do I..." question in the Project Customization and Programming forum at:

    http://social.technet.microsoft.com/Forums/en-US/project2010custprog

    Hope this helps.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Monday, October 17, 2011 11:32 AM
  • Hi,

    Just to update this thread, i have written my custom programming to send alerts to TM and Resource when a timesheet is submitted as well approved/rejected by TM.

     

    Thanks


    Ravishankar Polepalli (MCP)
    Microsoft Dynamics, Project Server and SharePoint Server Consultant
    ravi.polepalli@gmail.com
    Monday, December 26, 2011 12:28 PM
  • Ravishankar --

    Good for you, my friend.  Well done!  :)

    "Ravishankar Polepalli" wrote in message news:5a600927-2b85-49ff-b900-3bd3d3669550@communitybridge.codeplex.com...

    Hi,

    Just to update this thread, i have written my custom programming to send alerts to TM and Resource when a timesheet is submitted as well approved/rejected by TM.

    Thanks


    Ravishankar Polepalli (MCP)
    Microsoft Dynamics, Project Server and SharePoint Server Consultant
    ravi.polepalli@gmail.com


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Tuesday, December 27, 2011 8:44 PM
  • I have created a database trigger to manage notifications for timesheet managers when timesheets are submitted and recalled, also this trigger sends email to the resource when timesheets have been approved or rejected.

    This trigger uses msdb.dbo.sp_send_dbmail and requires that you set up a profile called "Default Email" and have a valid configuration.  I did not put the @profile_name as a variable, but is easy enough to do for code portability.

    Since it uses database mail, it may not be appropriate for very large or busy timesheet sites, as the sp does use resources on the SQL server.

    This trigger needs to be installed in the dbo.MSP_Timesheet table.

    I hope this helps someone who spent as much time as I did looking for a solution.

    Please note that I am NOT a coder and this is one of my first attempts at writing a trigger in SQL.

    Feel free to mod it, improve it or distribute it as you see fit.

    Thanks,

    Scott Brawner

    Link to code
    • Edited by SkotB Wednesday, January 25, 2012 2:12 PM link sql file
    Wednesday, January 25, 2012 2:11 PM
  • Hi,

    I do not want the Timesheet alerts/notifications to be sent to manager / resource. Where can I perform the settings for the same?

    All other alerts are needed except Timesheet ones.

    Kindly help.

    Thanks,

    Anuja


    • Edited by Anuja Pawar Wednesday, September 10, 2014 4:06 PM To update query
    Wednesday, September 10, 2014 4:03 PM
  • Scott,

    Thanks a lot for sharing the sql query !!!

    I recently started working in Project Server 2013 with no knowledge and I was looking for some help in writing the sql to send notification for rejected time sheets.

    Your article is of great help :)

    Thanks,

    Meena.

    Monday, January 25, 2016 8:33 PM
  • Could You share?
    Thursday, December 7, 2017 4:16 PM