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.