The EXECUTE permission was denied on the object 'sp_add_job', database 'msdb', schema 'dbo'.

*** We are Self-Hosted ***

When trying to generate counts on an extraction in TEST, I'm getting the following message:

Error occurred while scheduling counts job: The EXECUTE permission was denied on the object 'sp_add_job', database 'msdb', schema 'dbo'.

I tried this from an older post but it didn't work::

use msdb
go
EXEC sp_addrolemember 'SQLAgentUserRole', 'guest'
go

Ashley Elliott

Database Administrator

St. Louis Symphony Orchestra

314-286-4198

ashleye@slso.org