locked
How to give Read-Only access to SQL Agent Jobs RRS feed

  • 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.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.

    • 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.

    • Proposed as answer by Fanny Liu Tuesday, May 14, 2013 10:56 AM
    • Marked as answer by Fanny Liu Wednesday, May 15, 2013 10:19 AM
    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.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.

    • 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.

    • Proposed as answer by Fanny Liu Tuesday, May 14, 2013 10:56 AM
    • Marked as answer by Fanny Liu Wednesday, May 15, 2013 10:19 AM
    Friday, May 10, 2013 7:23 AM