So I’ve just installed SCOM 2016 in my lab (well actually I’ve probably done it over a dozen times this weekend testing out scripts etc) and my Management Server suddenly popped up this message (after selecting the new Maintenance Schedules in the SCOM Console).
Date: 10/15/2016 8:39:18 PM
Application: Operations Manager
Application Version: 7.2.11719.0
The EXECUTE permission was denied on the object ‘sp_help_jobactivity’, database ‘msdb’, schema ‘dbo’.
The data access service account might not have the required permissions
So clearly on the last line its telling us that the stored procedure can’t be executed due to inadequate permissions assigned to our DAS account.
Also in the event logs, I saw a flood of the following events, 26319 and 33333.
The solution is to open up the SQL Management Studio and run this statement…just change [culham\s-scomdas] to that of your own DAS account.
Grant Execute ON OBJECT::[dbo].[sp_help_jobactivity] To [culham\s-scomdas]
And the problem is solved 🙂