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

Answer 1

Hi,

try this,

use msdb
EXECUTE sp_addrolemember 'SQLAgentReaderRole', 'username'
GO

Try these links:
http://msdn.microsoft.com/en-us/library/ms190926.aspx

http://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.

Answer 2

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.