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 nameData typeDescription
subsystem_idintID of the subsystem. This value corresponds to the subsystem_id column in the syssubsystems table.
proxy_idintID 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.

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

Community Additions