Export (0) Print
Expand All

dbo.syssubsystems (Transact-SQL)

Contains information about all available SQL Server Agent proxy subsystems. The syssubsystems 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.

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.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft