bret.christoe (9/17/2012)
The SQLAgent job is dependent on the privileges of the SQL Server Agent service.
This is true only when the job is owned by a member of the sysadmin Fixed Server Role.
If the job is owned by a non-sysadmin then each job step runs in the security context of the job owner unless the job step is using a proxy account in which case it executes in the context of the proxy account.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato