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 nameData typeDescription
subsystem_idintID of the subsystem.
subsystemnvarchar(40)Name of the subsystem.
description_idintMessage ID of the row in the sys.messages catalog view that contains the subsystem description.
subsystem_dllnvarchar(255)Location of the subsystem DLL.
agent_exenvarchar(255)Full path to the executable that uses the subsystem.
start_entry_pointnvarchar(30)Function that is called when the subsystem is initialized.
event_entry_pointnvarchar(30)Function that is called when a subsystem step is run.
stop_entry_pointnvarchar(30)Function that is called when a subsystem finishes running.
max_worker_threadsintMaximum number of concurrent steps for a given subsystem.

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

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

Community Additions