SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

Peter99
Constraint Violating Yak Guru

481 Posts

Posted - 09/24/2012 :  16:24:38  Show Profile  Reply with Quote
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

India
52249 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
http://visakhm.blogspot.com/

Go to Top of Page

Peter99
Constraint Violating Yak Guru

481 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:

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

Thanks

Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.05 seconds. Powered By: Snitz Forums 2000