48 lines (42 loc) · 2.23 KB

title

dbo.syssubsystems (Transact-SQL) | Microsoft Docs

ms.custom

ms.date

03/14/2017

ms.prod

sql

ms.prod_service

database-engine

ms.reviewer

ms.technology

system-objects

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

author

stevestein

ms.author

sstein

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.

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)