Share via


JobServer.MsxDefect Method (Boolean)

Ends SQL Server Agent participation in a multiserver administration group with the option to force defection.

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

Syntax

'Declaration
Public Sub MsxDefect ( _
    forceDefection As Boolean _
)
'Usage
Dim instance As JobServer 
Dim forceDefection As Boolean

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

Parameters

  • forceDefection
    Type: System.Boolean
    A Boolean value that specifies whether to allow for a forceful removal of the target server when the master server connection has been permanently lost. If True, the forceful removal of the target server is allowed.If False, the removal of the target server is not forced.

Remarks

Use the forceDetection parameter with caution, because if the master server still has the target server registered, the target server must be manually removed from the master server.

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)