Поделиться через

  • Статья

Свойство HasServer

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

Пространство имен:  Microsoft.SqlServer.Management.Smo.Agent
Сборка:  Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property HasServer As Boolean
    Get
'Применение
Dim instance As Job
Dim value As Boolean

value = instance.HasServer

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

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

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member HasServer : bool

function get HasServer () : boolean

Значение свойства

Тип: 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