JobServer.EnumSubSystems Method
Enumerates a list of Microsoft SQL Server Agent execution subsystems.
네임스페이스: Microsoft.SqlServer.Management.Smo.Agent
어셈블리: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
구문
‘선언
Public Function EnumSubSystems As DataTable
public DataTable EnumSubSystems ()
public:
DataTable^ EnumSubSystems ()
public DataTable EnumSubSystems ()
public function EnumSubSystems () : 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. |
주의
이 네임스페이스, 클래스 또는 멤버는 Microsoft .NET Framework 2.0 버전에서만 지원됩니다.
예
How to: Create a Job with Steps and a Schedule in Visual Basic .NET
스레드 보안
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.
플랫폼
개발 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
대상 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
참고 항목
참조
JobServer Class
JobServer Members
Microsoft.SqlServer.Management.Smo.Agent Namespace
관련 자료
관리 작업 자동화(SQL Server 에이전트)
Scheduling Automatic Administrative Tasks in SQL Server Agent
sp_enum_sqlagent_subsystems(Transact-SQL)