Forum Discussion
Julien4
Dec 16, 2020Copper Contributor
MSSQL 2019 - SQL Server Agent - Jobs account
Hi everyone, I have a question regarding the execution of jobs in MSSQL 2019. I’m managing several MSSQL servers but I’m not a DBA so maybe my question will sound vapid. On a SQL mono-instan...
Julien4
Dec 17, 2020Copper Contributor
According to this link https://docs.microsoft.com/en-us/sql/ssms/agent/manage-job-steps?view=sql-server-ver15#transact-sql-job-steps, for my understanding, it confirms how I was understanding that. So in my case, the user "Bob" who creates job is not sysadmin, so jobs are running with the account specified as being the owner. By default the owner is the user "Bob" who created the job. Now my goal is to avoid any service interruption the day we disable the account of the user "Bob" who created jobs. I could create another account "jobexec_acc", granting it just necessary permissions in order to execute jobs. In my case, the user "Bob" cannot change the owner of jobs he creates/created. Does it mean a DBA needs to do that? Once more, I'm not DBA so I don't know if it is the good way to go for managing SQL servers. Basically, my question is, do you have recommendation for best practices for managing jobs? Thank you