Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

dbo.sysproxysubsystem (Transact-SQL)

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

Applies to: SQL Server (SQL Server 2008 through current version).

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.

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

Community Additions

Show:
© 2015 Microsoft