dbo-sysproxysubsystem-transact-sql.md

title	dbo.sysproxysubsystem (Transact-SQL)
description	dbo.sysproxysubsystem (Transact-SQL)
author	VanMSFT
ms.author	vanto
ms.date	03/14/2017
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
f1_keywords	dbo.sysproxysubsystem_TSQL dbo.sysproxysubsystem sysproxysubsystem_TSQL sysproxysubsystem
helpviewer_keywords	sysproxysubsystem system table
dev_langs	TSQL

dbo.sysproxysubsystem (Transact-SQL)

[!INCLUDE SQL Server]

Records which [!INCLUDEssNoVersion] 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)