Brandie Tarvin (6/20/2013)
Does this make sense to everyone? MSDB being owned by SA would force other accounts to use its credentials when running jobs?
Not me or I wouldn't be asking such questions. LOL. 🙂
First, on the trace, I would say that yes, it would be an open ended trace that was specific in filtering for the procedure the job is running to see if you can get any further information on what might be different between one run and the other.
Also, another "out there" question, is the machine that this job is on in a DMZ or something like that where you may be experiencing a double-hop issue and thereby the credentials of the executor are not being shown?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot