[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

modify SQL Agent jobs that he does not own

http://borishristov.com/blog/modifying-not-owned-sql-agent-jobs-without-being-a-sysadmin/

Hi,

There are 3 built in Agent roles (SQLAgentXXXRole): User, Reader, Operator
None of these fit your needs, if I understood you correctly

>> From the BOL: Unless you are a member of the sysadmin fixed server role, you can only modify jobs that you own:
https://msdn.microsoft.com/en-us/library/ms190948.aspx