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)

Help and Information

Getting SQL Server 2005 Assistance