EnumSubSystems Method (SQL-DMO)

The EnumSubSystems method returns a QueryResults object enumerating installed SQL Server Agent execution subsystems.

Applies To

JobServer Object

Syntax

object.EnumSubSystems() as QueryResults

Part Description
object Expression that evaluates to an object in the Applies To list

Returns

A QueryResults object containing one result set defined by these columns.

Column Data type Description
subsystem nvarchar(41) Name of the subsystem. The subsystem is specified by name when creating a job step.
description nvarchar(81) Descriptive text.
subsystem_dll nvarchar(81) Dynamic link library implementing execution subsystem.
agent_exe nvarchar(81) When applicable, executable file launched by agent. Reserved.
start_entry_point nvarchar(31) Name of an exported function. Reserved.
event_entry_point nvarchar(31) Name of an exported function. Reserved.
stop_entry_point nvarchar(31) Name of an exported function. Reserved.
max_worker_threads integer Reserved.

Prototype (C/C++)

HRESULT EnumSubSystems(
LPSQLDMOQUERYRESULTS* ppResults);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.