Udostępnij za pośrednictwem


HasSchedule Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Syntax

object
.HasSchedule

Parts

  • object
    An 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 is empty.

Applies To:

Job Object