AndrewL65 (12/1/2016)
I have a team of developers who have traditionally managed their own agent jobs. I'm now trying to remove their sysadm access to the live servers but this will also remove their ability to manage jobs now owned by them.Has anyone come across a way to do this? Giving them SQLAgentOperator role only allows them to alter jobs owned by themselves (useless for a group of people).
I think Idera have a program to do this but then again it required sysadm access (also the Enterprise version is a bit pricey)...
You might want to take a look at using proxy accounts for this - that's what we've done in the past.
Steps to do this are in the MS documentation:
https://msdn.microsoft.com/en-us/library/ms187901.aspx
Sue