Export (0) Print
Expand All

dbo.sysproxysubsystem (Transact-SQL)

Records which SQL Server Agent subsystem is used by each proxy account. This table is stored in the msdb database.

Applies to: SQL Server (SQL Server 2008 through current version).

Column name

Data type

Description

subsystem_id

int

ID of the subsystem. This value corresponds to the subsystem_id column in the syssubsystems table.

proxy_id

int

ID of the proxy account. This value corresponds to the proxy_id column in the sysproxies table.

Only members of the sysadmin fixed server role can access this table.

Community Additions

ADD
Show:
© 2014 Microsoft