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.