SQL Server Performance

sql agent proxies

Discussion in 'SQL Server 2008 General DBA Questions' started by Trev256b, May 24, 2011.

  1. Trev256b Member

    what are sql agent proxies?
  2. satyaskj New Member

    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.

Share This Page