November 26, 2007 at 2:28 am
Is there a relationship between the SQL Server Service startup account and owners of jobs? I seemed to remember reading something about this in relation to jobs failing.
November 26, 2007 at 2:53 am
No, there no relationship I'm aware of between jobowners and the SQL Server Service account.
I think what you mean is the SQL Server Agent service account. If the jobowner is a SQL login (like "sa") access to the OS g.e. a backup folder is made under the permissions of the SQL Server Agent service account. For jobsteps which execute something other than T-SQL task you can define a proxy account under which security context the task will run.
Hope this helps
Markus
[font="Verdana"]Markus Bohse[/font]
November 26, 2007 at 4:15 am
This is what I found!
"If the job step is a T-SQL step and if the job owner is an account that is in the sysadmin fixed server role, than your step will be executed under the account used by the Sql Server Agent service.
Otherwise will be executed by the account set as the job owner."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply