dbo.syssubsystems (Transact-SQL)
Applies to: 
SQL Server
Contains information about all available SQL Server 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)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for