Propriété JobServer.SqlAgentRestart
Gets or sets the Boolean property value that specifies whether SQL Server Agent is monitored and restarted if it stops.
Espace de noms : Microsoft.SqlServer.Management.Smo.Agent
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public Property SqlAgentRestart As Boolean
Get
Set
'Utilisation
Dim instance As JobServer
Dim value As Boolean
value = instance.SqlAgentRestart
instance.SqlAgentRestart = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool SqlAgentRestart { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool SqlAgentRestart {
bool get ();
void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member SqlAgentRestart : bool with get, set
function get SqlAgentRestart () : boolean
function set SqlAgentRestart (value : boolean)
Valeur de propriété
Type : System.Boolean
A Boolean value that specifies whether SQL Server Agent is monitored and restarted if it stops.If True, SQL Server Agent is restarted.If False (default), SQL Server Agent is not restarted.
Exemples
Planification des tâches administratives automatiques dans l'Agent SQL Server
Voir aussi
Référence
Espace de noms Microsoft.SqlServer.Management.Smo.Agent