Type Property (JobServer)

SQL-DMO

Type Property (JobServer)

The Type property exposes configured attributes of the referenced Microsoft® SQL Server™ 2000 component.

Applies To

JobServer Object

Syntax

object.Type

Parts

object

Expression that evaluates to an object in the Applies To list

Data Type

Long, enumerated

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetType(SQLDMO_JOBSERVER_TYPE* pRetVal)

Returns

For the JobServer object, interpret the Type property using these values.

Constant	Value	Description
SQLDMOJobServer_MSX	3	An instance of SQL Server participates in multiserver administration. Current instance of SQL Server masters administration for other servers.
SQLDMOJobServer_StandAlone	1	Current instance of SQL Server does not participate in multiserver administration.
SQLDMOJobServer_TSX	2	Current instance of SQL Server participates in multiserver administration. Current instance of SQL Server is a target for administration.
SQLDMOJobServer_Unknown	0	Bad or invalid value.

Remarks

Create master servers (MSXs) using SQL-DMO by adding a SQL Server Agent MSX operator to those instances of SQL Server that will master a multiserver administration group. Use the MSXEnlist and MSXDefect methods of the JobServer object referencing a target server to manage group membership.