共用方式為


Job.HasStep 屬性

Gets the Boolean property value that specifies whether the job has at least one job step.

命名空間:  Microsoft.SqlServer.Management.Smo.Agent
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property HasStep As Boolean 
    Get
'用途
Dim instance As Job 
Dim value As Boolean 

value = instance.HasStep
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public bool HasStep { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property bool HasStep {
    bool get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member HasStep : bool
function get HasStep () : boolean

屬性值

型別:System.Boolean
A Boolean value that specifies whether the job has at least one job step.If True, the job has at least one job step. If False, the job does not have any job steps.

備註

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

範例

The following code example indicates whether the job has at least one job step.

C#

Server srv = new Server("(local)");
Job jb = new Job(srv.JobServer, "Test Job");
Console.WriteLine(jb.HasStep);

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$jb = new-object Microsoft.SqlServer.Management.Smo.Agent.Job($srv.JobServer, "Test Job")
Write-Host $jb.HasStep 

請參閱

參考

Job 類別

Microsoft.SqlServer.Management.Smo.Agent 命名空間

其他資源

自動化管理工作 (SQL Server Agent)

sp_add_job (Transact-SQL)

使用 SQL Server Agent 排程自動管理工作