Tell me more ×
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. It's 100% free, no registration required.
up vote 3 down vote favorite 
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

1 Answer

up vote 4 down vote

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

 
discard

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.