JobServer.SqlAgentAutoStart Property

Gets or sets the Boolean property value that specifies whether SQL Server Agent is automatically started.

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 SqlAgentAutoStart As Boolean 
    Get 
    Set
'Usage
Dim instance As JobServer 
Dim value As Boolean 

value = instance.SqlAgentAutoStart

instance.SqlAgentAutoStart = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool SqlAgentAutoStart { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool SqlAgentAutoStart {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member SqlAgentAutoStart : bool with get, set
function get SqlAgentAutoStart () : boolean 
function set SqlAgentAutoStart (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether SQL Server Agent is automatically started.If True, SQL Server Agent is automatically started.If False, (default), SQL Server Agent is not automatically 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)