JobServer.EnumSubSystems Method
Enumerates a list of Microsoft 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
public DataTable EnumSubSystems ()
public:
DataTable^ EnumSubSystems ()
public DataTable EnumSubSystems ()
public function EnumSubSystems () : DataTable
Rückgabewert
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. |
Hinweise
Der Namespace, die Klasse oder das Element wird nur in der Version 2.0 von Microsoft .NET Framework unterstützt.
Beispiel
How to: Create a Job with Steps and a Schedule in Visual Basic .NET
Threadsicherheit
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Plattformen
Entwicklungsplattformen
Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.
Zielplattforme
Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.
Siehe auch
Verweis
JobServer Class
JobServer Members
Microsoft.SqlServer.Management.Smo.Agent Namespace
Andere Ressourcen
Automatisieren administrativer Tasks (SQL Server-Agent)
Scheduling Automatic Administrative Tasks in SQL Server Agent
sp_enum_sqlagent_subsystems (Transact-SQL)