Constraint Violating Yak Guru
Posted - 09/24/2012 : 16:24:38
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?