sp_enum_sqlagent_subsystems (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Lists the SQL Server Agent subsystems.

||
|-|
|Applies to: SQL Server ( SQL Server 2008 through current version).|

Topic link icon Transact-SQL Syntax Conventions

Syntax


sp_enum_sqlagent_subsystems  

Arguments

None

Return Code Values

0 (success) or 1 (Failure)

Result Sets

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 will start 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.

See Also

Implement SQL Server Agent Security
sp_add_jobstep (Transact-SQL)