The job of a Project Server Administrator (PSA) requires commitment, endurance & motivation. Besides regular user support work, PSA has to perform a lot of tasks on a regular basis to keep the EPM running smoothly. I will not go into the details of each topic but will just give some highlights here:
a. Daily Tasks
- OLAP Cube status check
- AD Sync status check
- Enterprise Resource Pool status check
- SQL Jobs (Backup, Portfolio, other scripts)
- Windows Scheduler jobs (if any)
- Check Windows Event Viewer logs for errors & warnings
- Check ‘Project Issues’ Sharepoint list for new issues posted by users
b. Weekly Tasks
- Close past Pay Periods
- Portfolio Analyzer Views
- Check Resources for correctness of RBS & other custom fields
- Backups (SQL databases, Enterprise Global Template, Sharepoint Sites backup)
- Sharepoint Sites
- Sharepoint Site Usage Analysis
c. Monthly Tasks
- Check Project Plans for correct information of owner, close finished projects, department, classification or other custom fields
- Resource Permissions & group membership review (those with higher privileges)
- Check the ‘Last Connected’ column in Admin > Users > Show Grid for users who haven’t logged on for long
- IIS Backup
- Logs Retention (Event Viewer logs, SQL logs, Sharepoint logs, Analysis Logs, Project Server Logs)
- Check number of Licenses in use
The order of a PSA tasks can be categorized differently in your organization. The above tasks list will give you an idea as to what needs to be done.