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
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property ForwardingServer As String
Get
Set
'Usage
Dim instance As AlertSystem
Dim value As String
value = instance.ForwardingServer
instance.ForwardingServer = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public string ForwardingServer { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property String^ ForwardingServer {
String^ get ();
void set (String^ value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member ForwardingServer : string with get, set
function get ForwardingServer () : String
function set ForwardingServer (value : String)
Property Value
Type: System.String
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.
Examples
Scheduling Automatic Administrative Tasks in SQL Server Agent
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace