Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-09-24 : 16:24:38
|
| Hi,Job A is schedule to run @ 10PM. SQL agent service runs under xxx\sqlagent account. That is Domain Account.In job properties, job owner shows xxx\12345.My question is:When this job will run through scheudle, whether it will run under xxx\sqlagent service account or xxx\12345 user acccount?In my environment, I have seen some job have owner that person already left. I am thinking to change job owner to my account to avoid any job failure becauase of pw expiry of that person. Another option I am thinking to create AD account and set job owner, set this account password never expire.First I want to make sure under which account this job is running. Under SQL Agent Service account or Job owner account?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-24 : 16:49:55
|
| See what account you've configured inside Run as options under job step.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-09-25 : 17:26:10
|
| Thanks for replay.Related issue:SQL Agent is running under local system account. I want to send backup from this server to file server that is on the same network. When I tried to run the job there is error:MessageThe job failed. Unable to determine if the owner (xxx\123) of job Test has server access (reason: Could not obtain information about Windows NT group/user 'xxx\123'. [SQLSTATE 42000] (Error 8198)).How to send backup on other server using local system account for sql agent?Note: user xxx/123 have access to file server.Thanks |
|
|
|
|
|
|
SQL Job run