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
Microsoft.SqlServer.Management.Smo.Agent Namespace