SQL-DMO

HasSchedule Property

The HasSchedule property reports whether a schedule exists for a SQL Server Agent job.

Applies To
Job Object

Syntax

object.HasSchedule

Parts

object

Expression that evaluates to an object in the Applies To list

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetHasSchedule(LPBOOL pRetVal);

Remarks

If TRUE, the job has at least one schedule. Query the JobSchedules collection to evaluate which schedule is enabled for the job.

If FALSE, the job has no schedule. The JobSchedules collection will be empty.