Job.HasServer Propiedad
Gets the Boolean property value that specifies whether the job has a target server assigned for multiple-server operations.
Espacio de nombres: Microsoft.SqlServer.Management.Smo.Agent
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property HasServer As Boolean
Get
'Uso
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
Valor de la propiedad
Tipo: 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.
Comentarios
The ApplyToTargetServer or ApplyToTargetServerGroup methods are used to set up target servers for multiserver jobs.
Ejemplos
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
Vea también
Referencia
Espacio de nombres Microsoft.SqlServer.Management.Smo.Agent
Otros recursos
Tareas administrativas automatizadas (Agente SQL Server)
Programar tareas administrativas automáticas en el Agente SQL Server