Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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