JobServer.EnumSubSystems Method
Enumerates a list of SQL Server Agent execution subsystems.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Function EnumSubSystems As DataTable
'Usage
Dim instance As JobServer
Dim returnValue As DataTable
returnValue = instance.EnumSubSystems()
public DataTable EnumSubSystems()
public:
DataTable^ EnumSubSystems()
member EnumSubSystems : unit -> DataTable
public function EnumSubSystems() : DataTable
Return Value
Type: System.Data.DataTable
A DataTable object value that contains a table of information about SQL Server Agent execution subsystems. The table describes the different columns of the returned DataTable.
Column |
Data type |
Description |
|---|---|---|
subsystem |
String |
The name of the subsystem. Examples of subsystems include the following: TSQL, CmdExec, ANALYSISQUERY, and LogReader. |
description |
String |
The textual description of the subsystem. |
subsystem_dll |
String |
The subsystem dynamic link library (DLL). This information might not be available. |
agent_exe |
String |
The subsystem executable program. This information might not be available. |
start_entry_point |
String |
The entry point in the code to start executing. |
event_entry_point |
String |
The code entry point for events |
stop_entry_point |
String |
The entry point in the code to stop executing. |
max_worker_threads |
Int32 |
The maximum number of worker threads available for execution of processes. |
susbsystem_ID |
Int32 |
The subsystem ID value. |
Examples
Scheduling Automatic Administrative Tasks in SQL Server Agent
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace