Discussion in 'SQL Server 2008 General DBA Questions' started by Trev256b, May 24, 2011.
what are sql agent proxies?
Just copying what is defined in SQL Server Books Online BOL -
A SQL Server Agent proxy defines the security context for a job step. A proxy provides SQL Server Agent with access to the security credentials for a Microsoft Windows user. Each proxy can be associated with one or more subsystems. A job step that uses the proxy can access the specified subsystems by using the security context of the Windows user. Before SQL Server Agent runs a job step that uses a proxy, SQL Server Agent impersonates the credentials defined in the proxy, and then runs the job step by using that security context.
Separate names with a comma.