通过

  • 项目

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:

JobServer Object