SQL Job

  • hello

    i have question about SQL Server Jobs

    I check the job properties and see the username is 'SA'. and i check into steps and there is no user is specify in "Run AS". but still it will take one other user as this job Executed as user: 'XXXXXXX'

    so how come it execute as XXXXXX user, why not sa?

  • Job does not run under owner's account.

    1) If you run a job manually, it runs using your login.

    2) If schedule it, job runs using SQL Server Agent service account.

  • Suresh B. (8/15/2012)


    Job does not run under owner's account.

    1) If you run a job manually, it runs using your login.

    2) If schedule it, job runs using SQL Server Agent service account.

    Who or what kicks the job off has nothing to do with which security context the job runs in. It has everything to do with the job owner and any proxy accounts setup for the steps.

    If the job owner is in the sysadmin Server Role then the job executes in the context of the SQL Server Agent service account.

    If the job owner is not in the sysadmin Server Role then the job executes in the context of the owner unless there are proxies setup for a step in which case that step runs in the context of the proxy account.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • surma.sql (8/15/2012)


    hello

    i have question about SQL Server Jobs

    I check the job properties and see the username is 'SA'. and i check into steps and there is no user is specify in "Run AS". but still it will take one other user as this job Executed as user: 'XXXXXXX'

    so how come it execute as XXXXXX user, why not sa?

    The account specified as XXXXXX will be the same as your SQL Server Agent service account.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply