Share via

TargetServer.Status Property

  • Article

Gets information about the current component execution status or integrity status of the referenced target server.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property Status As TargetServerStatus 
    Get
'Usage
Dim instance As TargetServer 
Dim value As TargetServerStatus 

value = instance.Status

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public TargetServerStatus Status { get; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property TargetServerStatus Status {
    TargetServerStatus get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member Status : TargetServerStatus

function get Status () : TargetServerStatus

Property Value

Type: Microsoft.SqlServer.Management.Smo.Agent.TargetServerStatus
A TargetServerStatus object value that specifies the current execution and integrity status of the target server.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

TargetServer Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_help_targetserver (Transact-SQL)