Re: SQL Server Agent

From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 16:59:14 -0400

Actually, the job will run as the job owner. If the job owner is sysadmin,
individual steps can run under different user rights.

The SQL Agent proxy account only affects resources outside of SQL Server.
So, xp_cmdshell, using DTSRUN, etc. will run as the SQL Agent proxy, if it
exists and the job is not running as sysadmin. But, if you are running a
command in those contexts, the proxy account must have the needed rights to
your database.

Russell Fields
"news" <t-marks@microsoft.com> wrote in message
news:40c8c2a5$1@news.microsoft.com...
> David,
>
> In SQL Server 2000 SP3, it works like this: If the owner of the job is a
> member of the sysadmin role, the job will be executed as the windows
account
> that SQL Server Engine is running as. Otherwise, the job will be with the
> privledges of the SQL Agent proxy account. Please see
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
xp_aa-sz_8sdm.asp
> for how to set this account. If you have any questions please let me know.
>
> Mark Shlimovich
>
>
> " David N" <dq.ninh@netiq.com> wrote in message
> news:unwObkxTEHA.3332@tk2msftngp13.phx.gbl...
> >
> > Hi All,
> >
> > Does the job's owner name have any thing to do with a SQL Server login
> when
> > SQL Server Agent running a job?
> >
> > Speaking otherwise, what login name SQL Agent will use when it runs a
> > scheduled job?
> >
> > Thanks
> >
> >
>
>

Quantcast