AndrewL65 (12/6/2016)
Hi Sue,I've tried this in the past and couldn't get it to work. I didn't think that creating a proxy would enable non sysadm users to modify any job.
Regards,
Andrew
If you need them to manage and edit any and all jobs then the only option is if they are sysadmins. There are other workarounds for various scenarios - using the roles, certificates, proxy accounts, etc. They could have a shared login which only have access to the jobs they own and limited privs with the agent roles but none of that will work since they need to edit all jobs.
Not sure why developers would be editing and managing backup jobs, index maintenance, etc.
Sue