Job Runs As Another User

• sgambale

  SSCommitted

  Points: 1709

  More actions

  May 18, 2010 at 9:46 am

  #221595

  Whenever I run a job or create a job, then run it, it executes as another id for which I never use and do not even have a password for.

  Where is this configured and how to I force a job to run as my id (assuming I have the proper privileges)?

  I'm thinking it's something to do with what id starts the sql server agent or similar to that.

  Steve

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  May 18, 2010 at 12:49 pm

  #1169039

  That's right. When you create a job, you're the owner, but it executes in the security context of the login that runs the SQL Agent service.

  You can create a SQL Agent proxy to run the job under another login. BOL has step-by-step instructions for creating a proxy.

  Greg