Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
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?

share|improve this question
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 '11 at 18:49

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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