sysproxysubsystem (Transact-SQL)

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

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.

Remarks

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