Job.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

请参阅

参考

Job 类

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

其他资源

自动执行管理任务(SQL Server 代理)

sp_add_job (Transact-SQL)

在 SQL Server 代理中计划自动管理任务