There is a team of five people that are currently sysadmins and I want to get them out of that role. The hanging point is an issue related to jobs:
Currently they all can create and modify each others' jobs and need to be able to continue to do that. Furthermore, I'd like them to be able to do that with their Win logins and not using a SQL Server login. How can I accomplish this?
I have tried some of the server roles (dbo, SQLServerOperator, etc.), but they do not allow this. I guess I'm looking for how a jobs ownership can be granted to other team members and am hoping there is some clever way to do this?