Export (0) Print
Expand All
Expand Minimize

sp_enum_sqlagent_subsystems (Transact-SQL)

Lists the SQL Server Agent subsystems.

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

Topic link icon Transact-SQL Syntax Conventions

sp_enum_sqlagent_subsystems

0 (success) or 1 (Failure)

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.

This procedure lists the subsystems available in the instance.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft