Type Property (JobServer) (SQL-DMO)

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

Applies To

Syntax

object.Type

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

Returns

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

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

Remarks

Create MSX servers using SQL-DMO by adding a SQL Server Agent MSX operator to those SQL Server installations 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.

Data Type

Long, enumerated

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetType(SQLDMO_JOBSERVER_TYPE* pRetVal)