Project Server Administrator - To Do List
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:
1. Daily Tasks
a. OLAP Cube status check
b. AD Sync status check
c. Enterprise Resource Pool status check
d. SQL Jobs (Backup, Portfolio, other scripts)
e. Windows Scheduler jobs (if any)
f. Check Windows Event Viewer logs for errors & warnings
g. Check 'Project Issues' Sharepoint list for new issues posted by users
2. Weekly Tasks
a. Close past Pay Periods
b. Portfolio Analyzer Views
c. Check Resources for correctness of RBS & other custom fields
d. Backups (SQL databases, Enterprise Global Template, Sharepoint Sites backup)
e. Sharepoint Sites
f. Sharepoint Site Usage Analysis
3. Monthly Tasks
a. Check Project Plans for correct information of owner, close finished projects, department, classification or other custom fields
b. Resource Permissions & group membership review (those with higher privileges)
c. Check the ‘Last Connected’ column in Admin > Users > Show Grid for users who haven't logged on for long
d. IIS Backup
e. Logs Retention (Event Viewer logs, SQL logs, Sharepoint logs, Analysis Logs, Project Server Logs)
f. 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.
