JobServer.MsxDefect Method

Ends Microsoft SQL Server Agent participation in a multiserver administration group. 

Namespace:  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Sub MsxDefect
'Usage
Dim instance As JobServer

instance.MsxDefect()
public void MsxDefect()
public:
void MsxDefect()
member MsxDefect : unit -> unit
public function MsxDefect()

Remarks

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

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

JobServer Class

MsxDefect Overload

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_msx_defect (Transact-SQL)