Edit

sp_enum_sqlagent_subsystems (Transact-SQL)

  • Article

Applies to: SQL Server

Lists the SQL Server Agent subsystems.

Transact-SQL syntax conventions

Syntax

sp_enum_sqlagent_subsystems
[ ; ]

Arguments

None.

Return code values

0 (success) or 1 (failure).

Result set

Column name Data type Description
subsystem nvarchar(40) Name of the subsystem.
description nvarchar(512) Description of the subsystem.
subsystem_dll nvarchar(510) DLL module that contains the subsystem.
agent_exe nvarchar(510) Executable module that is used by the subsystem.
start_entry_point nvarchar(30) Procedure that SQL Server Agent calls during job step execution.
event_entry_point nvarchar(30) Procedure that SQL Server Agent calls during job step execution.
stop_entry_point nvarchar(30) Procedure that SQL Server Agent calls during job step execution.
max_worker_threads int Maximum number of threads SQL Server Agent starts for this subsystem.
subsystem_id int Identifier for the subsystem.

Remarks

This procedure lists the subsystems available in the instance.

Permissions

By default, members of the sysadmin fixed server role can execute this stored procedure. Other users must be granted the SQLAgentOperatorRole fixed database role in the msdb database.

For details about SQLAgentOperatorRole, see SQL Server Agent Fixed Database Roles.

Related content