次の方法で共有

TargetServer Object

  • [アーティクル]

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

The TargetServer object represents an instance of Microsoft SQL Server on which a SQL Server Agent job is to run.

現在のオブジェクトを表す SQL-DMO オブジェクト モデル

Properties

EnlistDate Property

PollingInterval Property

LastPollDate Property

ServerID Property

LocalTime Property

ServerName Property

Location Property (TargetServer)

Status Property (TargetServer)

PendingInstructions Property

TimeZoneAdjustment Property

Methods

Refresh Method

解説

A SQL Server Agent job has an execution target. The SQL Server Agent can direct job execution from one instance of SQL Server to another within the same organization. Servers can enlist in the domain specified by a master SQL Server Agent. When a server enlists in a domain, it becomes a target server for job execution managed by the master SQL Server Agent.

Any instance on which SQL Server Agent is running provides the local instance as a valid target for job execution.

Target servers are defined only on a master SQL Server Agent, and the SQL Distributed Management Objects (SQL-DMO) TargetServers collection and each TargetServer object are populated only when SQL-DMO applications connect to an instance of SQL Server identified as the master in a multi-server administration group.

With the TargetServer object, you can:

  • Report the properties of a server that is an existing target in a multi-server administration group.
  • Set the location string for a server that is an existing target in a multi-server administration group.