6
The select permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'. 

I have already tried to grant sqlagentoperatorrole and it didn't work. How do I resolve this error?

1
  • I have the same issue and tried already the steps outlined in the MSDN link. It doesn't work. Is there any restrictions on how this should work on SQL 2008 R2?
    – user4615
    Nov 21, 2011 at 18:49

1 Answer 1

5

You use the "SQL Server Agent Fixed Database Roles" in msdb (MSDN link).

And a "how to" for SSMS: "How to: Configure a User to Create and Manage SQL Server Agent Jobs (SQL Server Management Studio)"

Note: you need a user (MSDN) in one of these roles: no need to GRANT rights to sqlagentoperator

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.