Type Property (JobServer)

發行項
12/15/2008

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能，並計劃修改目前使用此功能的應用程式。

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

語法

object
.Type

Parts

object
An 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. The current instance of SQL Server masters administration for other servers.
SQLDMOJobServer_StandAlone	1	The current instance of SQL Server does not participate in multiserver administration.
SQLDMOJobServer_TSX	2	The current instance of SQL Server participates in multiserver administration. The current instance of SQL Server is a target for administration.
SQLDMOJobServer_Unknown	0	The value is not valid.

備註

Create master servers using SQL-DMO by adding a SQL Server Agent master server 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.