• 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