HasStep Property

SQL-DMO

SQL-DMO

HasStep Property

The HasStep property reports the presence of at least one job step for the job.

Applies To
Job Object
Syntax

object.HasStep

Parts

object

Expression that evaluates to an object in the Applies To list

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetHasStep(LPBOOL pRetVal);

Remarks

If TRUE, the job has at least one step (the JobSteps collection of the Job object contains at least one member) and may be available for execution.

If FALSE, the job does not have an execution target set.

SQL Server Agent jobs must have at least one job step and must be targeted to a server to be executable. Define and add JobStep objects to the JobSteps collection of a Job object to create job steps and alter the value of HasStep.