Dec 16 2020 09:55 AM
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-instance server, I have a user who is member of “ SQLAgentUserRole” on the database “msdb”.
He created jobs and is owner of these jobs.
For what I read (and understood), jobs are executed with the service account running the service “SQL Server Agent” if and only if, the owner of this job is sysadmin (which is not the case for me).
Unfortunately, I cannot find MS documentation confirming that.
Could someone please explain me that (MS documentation would be ideal).
Now, let’s assume I understood well, and jobs are running with the account specified as the job owner. What would be the best practice to manage these jobs? Should the user change the owner when he creates a job?
Thank you for your answers.
Dec 16 2020 04:51 PM
Dec 18 2020 08:50 AM