Share via

Job.Parent Property

  • Article

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

Namespace:  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcObjectAttribute(SfcObjectRelationship.ParentObject)> _
Public Property Parent As JobServer 
    Get 
    Set
'Usage
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)

Property Value

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

Remarks

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

Examples

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()

See Also

Reference

Job Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_add_job (Transact-SQL)

Scheduling Automatic Administrative Tasks in SQL Server Agent