dbo-syssubsystems-transact-sql.md

title	dbo.syssubsystems (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	dbo.syssubsystems syssubsystems syssubsystems_TSQL dbo.syssubsystems_TSQL
dev_langs	TSQL
helpviewer_keywords	syssubsystems system table
ms.assetid	114b3d55-1ad6-4777-b868-8ef0c86ba596
caps.latest.revision	14
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

dbo.syssubsystems (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

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

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version).

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)