dbo-syssubsystems-transact-sql.md

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

dbo.syssubsystems (Transact-SQL)

[!INCLUDE SQL Server]

Contains information about all available [!INCLUDEssNoVersion] Agent proxy subsystems. The syssubsystems table is stored in the msdb database.

Column name	Data type	Description
subsystem_id	int	ID of the subsystem.
subsystem	nvarchar(40)	Name of the subsystem.
description_id	int	Message ID of the row in the sys.messages catalog view that contains the subsystem description.
subsystem_dll	nvarchar(255)	Location of the subsystem DLL.
agent_exe	nvarchar(255)	Full path to the executable that uses the subsystem.
start_entry_point	nvarchar(30)	Function that is called when the subsystem is initialized.
event_entry_point	nvarchar(30)	Function that is called when a subsystem step is run.
stop_entry_point	nvarchar(30)	Function that is called when a subsystem finishes running.
max_worker_threads	int	Maximum number of concurrent steps for a given subsystem.

Remarks

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

See Also

dbo.sysproxysubsystem (Transact-SQL)
dbo.sysproxies (Transact-SQL)
sys.messages (Transact-SQL)