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...
In msdb, there are 3 fixed roles related to sql agent and none of them can edit the jobs.
Solution: You can use shared job owner.
Create a shared login
Assign all the jobs to that shared owner
All your 3 DBAs should have SQLAgentOperatorRole permission.