Partager via


Propriété Job.HasSchedule

Gets the Boolean property value that specifies whether the job has at least one schedule.

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.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property HasSchedule As Boolean 
    Get
'Utilisation
Dim instance As Job 
Dim value As Boolean 

value = instance.HasSchedule
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public bool HasSchedule { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property bool HasSchedule {
    bool get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member HasSchedule : bool
function get HasSchedule () : boolean

Valeur de propriété

Type : System.Boolean
A Boolean value that specifies whether the job has a schedule assigned or not.If True, the job has at least one schedule. If False (default), the job has no schedule.

Notes

You can query the JobSchedules collection property to evaluate which schedule is enabled for the job. If the HasSchedule property is False, the JobSchedules collection property is empty.

Exemples

The following code example specifies that the job has at least one schedule.

C#

Server srv = new Server("(local)");
Job jb = new Job(srv.JobServer, "Test Job");
jb.HasSchedule = true;

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$jb = new-object Microsoft.SqlServer.Management.Smo.Agent.Job($srv.JobServer, "Test Job")
$jb.HasSchedule = $TRUE

Voir aussi

Référence

Job Classe

Espace de noms Microsoft.SqlServer.Management.Smo.Agent

Autres ressources

Tâches d'administration automatisée (Agent SQL Server)

sp_add_job (Transact-SQL)

Planification des tâches administratives automatiques dans l'Agent SQL Server