通过

Job.OriginatingServer Property

  • 项目

Gets the name of the server that is acting as the master server in a multiserver job.

命名空间: Microsoft.SqlServer.Management.Smo.Agent
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public ReadOnly Property OriginatingServer As String

public string OriginatingServer { get; }

public:
property String^ OriginatingServer {
    String^ get ();
}

/** @property */
public String get_OriginatingServer ()

public function get OriginatingServer () : String

属性值

A String value that specifies the name of the master server where the job definition originates from.

备注

The property returns the string (local) for jobs created on the referenced instance of Microsoft SQL Server. For jobs assigned to the referenced instance of SQL Server by another server acting as a master server, the property returns the master server name.

仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。

示例

How to: Create a Job with Steps and a Schedule in Visual Basic .NET

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

Job Class
Job Members
Microsoft.SqlServer.Management.Smo.Agent Namespace

其他资源

Scheduling Automatic Administrative Tasks in SQL Server Agent
自动执行管理任务（SQL Server 代理）
sp_add_job (Transact-SQL)