Periodic Tasks for Project Server Administrators
- Check the queue for Failed and Blocking jobs.
- Review the errors related to failed and blocking jobs to troubleshoot.
- Check for nightly cube build failures.
- Cancel Failed and Blocking jobs.
- Review application and event logs on WFEs, APP servers, and the SQL Server.
- Use the ULS logs, as needed, based on the finding in the application and system event logs. Use merge-splogfile PowerShell cmdlet to filter output from all servers: https://technet.microsoft.com/en-us/library/ff607721(v=office.15).aspx
- Check AD synchronization jobs to ensure they were successful.
- Update resource RBS values for new users. Newly synched users won’t have an RBS. Note: this may be the job of the PMO.
- Clear any overly long delegation sessions in Server Settings > Delete Enterprise Objects > User Delegation.
- Provide Timesheet training to new users.
- Provide Project Manager training to new project managers.
- Close timesheet periods for the previous quarter plus 1. For example, if you are in Q4, close the timesheet reporting periods for Q2.
- Check with the Project Manager first, then close tasks to updates on projects that are complete, mostly compete, or have older tasks.
- Archive and delete projects/sites for old completed project plans. (But first, create an archive plan that is documented and adhered to.)
- Generally speaking, don’t ever delete any resources from Server Settings > Delete Enterprise Objects.
- Delete timesheets from the past. Again this will be defined by a policy that is based on business needs for reporting timesheet data.
- No recommendations, currently.
- Create fiscal periods for the next calendar year.
- Create timesheet periods for the next calendar year. Prefix might equal “Week.”, starting at 1, and the suffix might be the calendar year, such as “.2016”. Week 1’s period will show as Week.1.2016.
- Consider deleting timesheets for long ago periods.