Access to Agent Jobs RRS feed

  • Question

  • Good Evening,

    I have come across an issue whereby we have granted an account SQLAgentOperatorRole, SQLAgentReaderRole & SQLAgentUserRole in msdb however when they try to expand SQL Server Agent > Jobs they receive the below error:

    The EXECUTE permission was denied on the object 'xp_sqlagent_enum_jobs', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)

    Does anyone know what i have missed?

    thanks in advance

    • Edited by JonGB Tuesday, October 11, 2016 3:50 PM
    Tuesday, October 11, 2016 3:49 PM

All replies