共用方式為


MSXEnlist Method

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

The MSXEnlist method initiates SQL Server Agent participation as a target for multiserver administration.

語法

object
.MSXEnlist(
MasterServer
,
Location
)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • MasterServer
    String naming a registered instance of Microsoft SQL Server.The instance must be configured as a multiserver administration master server.
  • Location
    String documenting the enlisting server's location. Used for user assistance only.

Prototype (C/C++)

HRESULT MSXEnlist(
SQLDMO_LPCSTR szServer,
SQLDMO_LPCSTR szLocation);

備註

For SQL Server, multiserver administration participation is configured by performing two tasks. An instance of SQL Server declares itself a multiserver administration master server (MSX) by creating an administering operator. One or more instances of SQL Server then enlist with the configured master server, becoming administration target servers (TSX).

SQL Server multiserver administration is implemented using a hub and spoke topology. A master server cannot enlist as a target of any other master server in an organization.

An instance of SQL Server participating as a target server cannot become the target of any other master server by using the MSXEnlist method. Use the MSXDefect method to break an existing master-target relationship prior to enlisting the target server in a new multiserver administration group.

ms136297.note(zh-tw,SQL.90).gif重要事項:
Only instances of SQL Server version 7.0 running on Microsoft Windows NT 4.0, Microsoft Windows 2000, Microsoft Windows Server 2003 can enlist as target servers.

Applies To:

JobServer Object