HasStep 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 HasStep property reports the presence of at least one job step for the job.

Syntax

object.HasStep

Parts

  • object
    An 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 (that is, 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.

Applies To: