The MSXEnlist method initiates SQL Server Agent participation as a target for multiserver administration.
object.MSXEnlist( MasterServer , Location )
Part | Description |
---|---|
object | Expression that evaluates to an object in the Applies To list. |
MasterServer | String naming a registered Microsoft® SQL Server™ installation. The installation must be configured as a multiserver administration master server. |
Location | String documenting the enlisting server’s location. Used for user assistance only. |
For SQL Server, multiserver administration participation is configured by performing two tasks. A SQL Server installation declares itself a multiserver administration master server (MSX) by creating an administering operator. One or more SQL Server installations then enlist with the configured MSX, becoming administration target servers (TSX).
SQL Server multiserver administration is implemented using a hub and spoke topology. An MSX cannot enlist as a target of any other MSX in an organization.
A SQL Server installation participating as a TSX cannot become the target of any other MSX 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.
Important Only installations of SQL Server version 7.0 running on Microsoft Windows NT can enlist as target servers.
HRESULT MSXEnlist(
SQLDMO_LPCSTR szServer,
SQLDMO_LPCSTR szLocation);