Answered by:
How to give Read-Only access to SQL Agent Jobs

Question
-
Hi Folks,
Could you please help me on how to give Read-Only access to SQL agent jobs?
Thanks in advance
Friday, May 10, 2013 6:19 AM
Answers
-
Hi,
try this,
use msdb EXECUTE sp_addrolemember 'SQLAgentReaderRole', 'username' GO
Try these links:
http://msdn.microsoft.com/en-us/library/ms190926.aspxhttp://msdn.microsoft.com/en-us/library/ms187750.aspx
sathya --------- Please Mark as answered if my post solved your problem and Vote as helpful if my post was useful.
- Proposed as answer by Sethu Srinivasan Friday, May 10, 2013 6:49 PM
- Marked as answer by Fanny Liu Wednesday, May 15, 2013 10:19 AM
Friday, May 10, 2013 6:35 AM -
http://www.techrepublic.com/blog/datacenter/how-do-i-assign-permissions-to-users-to-see-sql-agent-jobs/428
includes sql 2000 & 2005+
Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.
Friday, May 10, 2013 7:23 AM
All replies
-
Hi,
try this,
use msdb EXECUTE sp_addrolemember 'SQLAgentReaderRole', 'username' GO
Try these links:
http://msdn.microsoft.com/en-us/library/ms190926.aspxhttp://msdn.microsoft.com/en-us/library/ms187750.aspx
sathya --------- Please Mark as answered if my post solved your problem and Vote as helpful if my post was useful.
- Proposed as answer by Sethu Srinivasan Friday, May 10, 2013 6:49 PM
- Marked as answer by Fanny Liu Wednesday, May 15, 2013 10:19 AM
Friday, May 10, 2013 6:35 AM -
http://www.techrepublic.com/blog/datacenter/how-do-i-assign-permissions-to-users-to-see-sql-agent-jobs/428
includes sql 2000 & 2005+
Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.
Friday, May 10, 2013 7:23 AM