Job.HasServer Property

 

Gets the Boolean property value that specifies whether the job has a target server assigned for multiple-server operations.

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

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Expensive | SfcPropertyFlags.Standalone)]
public bool HasServer { get; }

Property Value

Type: System.Boolean

A Boolean value that specifies whether the job is assigned to run on at least one remote target server.

If True, the job is assigned to run on at least one remote target server.

If False (default), the job runs on the local server.

The ApplyToTargetServer or ApplyToTargetServerGroup methods are used to set up target servers for multiserver jobs.

The following code example specifies that the job is assigned to run on at least one remote server.

C#

Server srv = new Server("(local)");
Job jb = new Job(srv.JobServer, "Test Job");
jb.HasServer = true;

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$jb = new-object Microsoft.SqlServer.Management.Smo.Agent.Job($srv.JobServer, "Test Job")
$jb.HasServer = $TRUE
Return to top
Show: