sp-enum-sqlagent-subsystems-transact-sql.md

title	sp_enum_sqlagent_subsystems (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_enum_sqlagent_subsystems sp_enum_sqlagent_subsystems_TSQL
dev_langs	TSQL
helpviewer_keywords	sp_enum_sqlagent_subsystems
ms.assetid	019a3c9d-bac3-495b-a70a-2c19f1d2e20e
author	stevestein
ms.author	sstein

sp_enum_sqlagent_subsystems (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Lists the [!INCLUDEssNoVersion] Agent subsystems.

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 [!INCLUDEssNoVersion] 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)