Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Job run
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Constraint Violating Yak Guru

498 Posts

Posted - 09/24/2012 :  16:24:38  Show Profile  Reply with Quote

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?


Very Important crosS Applying yaK Herder

52326 Posts

Posted - 09/24/2012 :  16:49:55  Show Profile  Reply with Quote
See what account you've configured inside Run as options under job step.

SQL Server MVP

Go to Top of Page

Constraint Violating Yak Guru

498 Posts

Posted - 09/25/2012 :  17:26:10  Show Profile  Reply with Quote
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:

The 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.


Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000