JobServer.EnumSubSystems 메서드
Enumerates a list of SQL Server Agent execution subsystems.
네임스페이스: Microsoft.SqlServer.Management.Smo.Agent
어셈블리: Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)
구문
‘선언
Public Function EnumSubSystems As DataTable
‘사용 방법
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
반환 값
유형: 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. |
예
SQL Server 에이전트에서 자동 관리 태스크 예약
참고 항목
참조
Microsoft.SqlServer.Management.Smo.Agent 네임스페이스