แชร์ผ่าน

AlertSystem.ForwardingServer Property

  • บทความ

Gets or sets the instance of Microsoft SQL Server that will receive forwarded events.

Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Property ForwardingServer As String

public string ForwardingServer { get; set; }

public:
property String^ ForwardingServer {
    String^ get ();
    void set (String^ value);
}

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

/** @property */
public void set_ForwardingServer (String value)

public function get ForwardingServer () : String

public function set ForwardingServer (value : String)

Property Value

A String value that specifies the instance of SQL Server that will receive forwarded events.

Remarks

SQL Server Agent can be configured to forward events to another instance of SQL Server. Alerts defined on the forwarding server are raised when a forwarded event is received.

The IsForwardedAlways property controls whether all events or only those that have no event notification are forwarded to the forwarding server. By default, the IsForwardedAlways property is set to forward events that do not have any event notification on the current instance of SQL Server.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.

Example

How to: Create an Alert in Visual Basic .NET

Thread Safety

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.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

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

Other Resources

Scheduling Automatic Administrative Tasks in SQL Server Agent
Automating Administrative Tasks (SQL Server Agent)
sp_add_alert (Transact-SQL)