共用方式為


Type Property (JobServer)

未來的 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.

[!附註]

For this property to work correctly the SQL Server Agent extended stored procedures must have been enabled using sp_configure.

Applies To: