none
How is a Resource Manager notified when a timesheet is overdue? RRS feed

  • Question

  • Hi Folks,

    In Project Server 2010 is there any way to notify a Resource Manager when a timesheet hasn't been sent at the end of the period???

    What is the easiest custom code solution to this problem ( if there is nothing OOB)?

    Carl

    Friday, May 25, 2012 10:35 PM

Answers

  • Hi There--

    I would say that you can write a Stored prc which get the records of the resources who has saved the Timesheet or not created from SQl query & use the XP_sendemail (http://msdn.microsoft.com/en-us/library/ms189505(v=sql.105).aspx) to each Resource Manager of Timesheet user , run it as a SQL job on each timesheet period end date (check the schedule to run the job as desired. hope that helps.

    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.
    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82


    Monday, May 28, 2012 10:44 AM

All replies

  • Hi Carl,

    First the ressource manager have to be the timesheet manager of those resources.

    After that go to http://Urserver/_layouts/pwa/Timesheet/TimesheetHistory.aspx (the resource manager did this.)You can reach this place from Server Setting -> Time and task Management -> Timesheet management.

    Hope it help!


    PWAdmin

    Saturday, May 26, 2012 12:36 PM
  • Hi There--

    I would say that you can write a Stored prc which get the records of the resources who has saved the Timesheet or not created from SQl query & use the XP_sendemail (http://msdn.microsoft.com/en-us/library/ms189505(v=sql.105).aspx) to each Resource Manager of Timesheet user , run it as a SQL job on each timesheet period end date (check the schedule to run the job as desired. hope that helps.

    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.
    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82


    Monday, May 28, 2012 10:44 AM