Post reply

Unable to View Jobs Even After Adding to MSDB SQLAgent... Roles

  • May 20, 2008 at 9:09 am

    #182591

    Developers need to view and modify jobs on some servers without being sysadmin. We've added the developers to the following MSDB roles:

    SQLAgentOperatorRole

    SQLAgentReaderRole

    SQLAgentUserRole

    Technically they should be able to view and modify jobs through Management Studio when being added only to SQLAgentOperatorRole. However they receive the following error when clicking on the Jobs folder regardless of the msdb role.

    Execute Permission Denied on Object 'xp_sqlagent_enum_jobs', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)

    Our original two SQL 2005 servers do not produce this message, but all other instances do. All servers, but one, are SP2 so the service pack is not an issue. Any thoughts?

    Thanks, Dave

  • May 22, 2008 at 6:24 pm

    #819450

    have u tryed BackupOperator role, and u can check if there is a deny any were in those roles.

    ..>>..

    MobashA

  • May 22, 2008 at 10:57 pm

    #819483

    There are no Denies.

  • October 22, 2008 at 2:07 pm

    #888339

    Hey in my system i dont even see jobs under management. Could anybody help to figure it out.

    Thanks

  • October 22, 2008 at 5:14 pm

    #888413

    Is SQL Server Agent running? If it is, what do you see when you expand it?

    Greg

  • October 23, 2008 at 10:22 am

    #888733

    Hi,

    Thanks for the response. I dont even see Sql server agent node in Management.

    I have granted sysadmin role and even set roles Sqlagent,sqloperator and sqluser in system db security roles.

    Please let me know if i am doing something wrong. i am new to this kind of stuff.

    Thanks

  • October 23, 2008 at 10:48 am

    #888741

    if sqlagent is not activated you may not see sqlagent stuff.

    you can use sp_configure to still have all sqlagent stuff visible.

    -- enable Agent XPs

    EXEC sp_configure 'Agent XPs','1'

    RECONFIGURE

    GO

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • October 24, 2008 at 9:08 am

    #889294

    It also occured to me that if you have Express Edition, SQL Server Agent isn't included.

    Greg

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply