select permission was denied on the object 'sysjobs'

Question

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?

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

gbn · Accepted Answer · 2011-06-09 05:25:25Z

5

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

answered Jun 9, 2011 at 4:45

gbn

69.7k8 gold badges162 silver badges243 bronze badges

Add a comment |

1 Answer 1