ForwardAlways Property

SQL-DMO

SQL-DMO

ForwardAlways Property

The ForwardAlways property controls event forwarding for SQL Server Agent.

Applies To
AlertSystem Object
Syntax

object.ForwardAlways [= value]

Part

object

Expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetForwardAlways(LPBOOL pRetVal);

HRESULT SetForwardAlways(BOOL NewValue);

Remarks

SQL Server Agent can be configured to forward events to another instance of Microsoft® SQL Server™. By default, when an event forward server is defined, the forwarding server forwards only events for which no alert notification mechanism exists.

If TRUE, all events on the forwarding server are directed to the forwarded server regardless of the presence of notifications for the event on the forwarding server.

If FALSE, only events with no alert notification available are forwarded from the forwarding server.