共用方式為


Job.Parent 屬性

Gets or sets the JobServer object that is the parent of the Job object.

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

語法

'宣告
<SfcObjectAttribute(SfcObjectRelationship.ParentObject)> _
Public Property Parent As JobServer 
    Get 
    Set
'用途
Dim instance As Job 
Dim value As JobServer 

value = instance.Parent

instance.Parent = value
[SfcObjectAttribute(SfcObjectRelationship.ParentObject)]
public JobServer Parent { get; set; }
[SfcObjectAttribute(SfcObjectRelationship::ParentObject)]
public:
property JobServer^ Parent {
    JobServer^ get ();
    void set (JobServer^ value);
}
[<SfcObjectAttribute(SfcObjectRelationship.ParentObject)>]
member Parent : JobServer with get, set
function get Parent () : JobServer 
function set Parent (value : JobServer)

屬性值

型別:Microsoft.SqlServer.Management.Smo.Agent.JobServer
A JobServer object value that specifies the parent of the Job object.

備註

The JobServer object represents the Microsoft SQL Server Agent running on the instance of SQL Server.

範例

The following code example sets the name and parent of a job, then creates it.

C#

Server srv = new Server("(local)");
Job jb = new Job();
jb.Name = "Test Job";
jb.Parent = srv.JobServer;
jb.Create();

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$jb = new-object Microsoft.SqlServer.Management.Smo.Agent.Job
$jb.Name = "Test Job"
$jb.Parent = $srv.JobServer
$jb.Create()

請參閱

參考

Job 類別

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

其他資源

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

sp_add_job (Transact-SQL)

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