When trying to generate counts on an extraction, I'm getting the following message:
Error occured while scheduling counts job: The EXECUTE permission was denied on the object 'sp_add_job', database 'msdb', schema 'dbo'.
Since this is a system proc in a system database, I can't modify the permissions on it. What am I missing?
This usually means that your Agent Proxy is not completely setup. Specifically, you probably need to add the guest user to the SQLAgentUserRole. Try this:
use msdb go EXEC sp_addrolemember 'SQLAgentUserRole', 'guest' go
If that does not work, here is a link to a KnowledgeBase article with more things to try:
http://www.tessituranetwork.com/network/Learning/Tessitura Knowledgebase/Extractions Lists/Other/16105.aspx
David
That seems to have fixed it.
Thanks!