sp_enum_sqlagent_subsystems (Transact-SQL)

Lists the SQL Server Agent subsystems.

Topic link iconTransact-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.