JobServer.SqlServerRestart Property

Gets or sets the Boolean property value that specifies whether the SQL Server Service is monitored and restarted if it stops.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public Property SqlServerRestart As Boolean 
    Get 
    Set
'Usage
Dim instance As JobServer 
Dim value As Boolean 

value = instance.SqlServerRestart

instance.SqlServerRestart = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool SqlServerRestart { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool SqlServerRestart {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member SqlServerRestart : bool with get, set

function get SqlServerRestart () : boolean 
function set SqlServerRestart (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether the SQL Server Service is monitored and restarted if it stops.If True, SQL Server Service is restarted.If False (default), SQL Server Service is not restarted.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

JobServer Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

SQL Server Agent Stored Procedures (Transact-SQL)