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.

See Also

Reference

syssubsystems (Transact-SQL)

sysproxies (Transact-SQL)