Problem
Attempting to automate some maintenance schedules using the new SCOM 2016 functionality and received the following error:
The Execute Permission Was Denied For Object ‘sp_help_jobactivity’.
Fix
Assign the following rights for the SCOM Data Access Service account (SDK service) against the msdb database:
- SQLAgentOperatorRole
- SQLAgentReaderRole
- SQLAgentUserRole
As always many thanks to Kevin Holman – more info about this issue here: https://blogs.technet.microsoft.com/kevinholman/2016/10/22/enabling-scheduled-maintenance-in-scom-2016-ur1/