Forum Discussion
Access to SQL Jobs
Hi, I have several jobs in SQL Server Agent. In the department there are 3 people who need administration access to the jobs. What kind of security access must they have? They already have SQL Agen...
There's no way to give multiple accounts edit permissions on a SQL Server agent job in SQL Server.
There's only the owner of the job, and accounts with sysadmin.
In order to give multiple users edit access to a job, you really need the job to exist in external source control with a deployment pipeline to SQL Server.