Assign a user to modify any schedule jobs RRS feed

  • Question

  • [SQL Server 2008 R2]

    I have assigned a user the role "SQLAgentOperatorRole" to handle any schedule jobs.

    However, it is found that they are not able to modify if he is not the owner of the job. Is there a way to allow to the user to handle any jobs only? There will be far too much privilege if we assign sysadmin to that user. Thanks

    Monday, March 30, 2015 3:59 AM


All replies