Applies To: SQL Server 2014, SQL Server 2016 Preview
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).
ID of the subsystem.
Name of the subsystem.
Message ID of the row in the sys.messages catalog view that contains the subsystem description.
Location of the subsystem DLL.
Full path to the executable that uses the subsystem.
Function that is called when the subsystem is initialized.
Function that is called when a subsystem step is run.
Function that is called when a subsystem finishes running.
Maximum number of concurrent steps for a given subsystem.
Only members of the sysadmin fixed server role can access this table.