dbo.sysproxysubsystem (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

See Also

dbo.syssubsystems (Transact-SQL)
dbo.sysproxies (Transact-SQL)