Brandie Tarvin (6/19/2013)
Sean Pearce (6/19/2013)
http://sqlblog.com/blogs/tibor_karaszi/archive/2009/09/19/sql-server-agent-jobs-and-user-contexts.aspxThanks for this link, but it doesn't quite help me figure out why it's changing my login context to 'sa'. I'm sysadmin, so it shouldn't do that so far as I know.
Unless something is going hooey between the context translation of me and the job owner (both accounts are sysadmin).
What does your job do (i.e., what kinds of steps - T-SQL commands, execute SSIS packages, etc.)? Do all steps happen on the same server\instance? What is the service account for the SQL Agent service?
Jason Wolfkill