HasSchedule Property (SQL-DMO)

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

Applies To

Job Object

Syntax

object.HasSchedule

Part Description
object Expression that evaluates to an object in the Applies To list

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.

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetHasSchedule(LPBOOL pRetVal);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.