Designate an Events Forwarding Server

Applies to: SQL Server Azure SQL Managed Instance

Important

On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance from SQL Server for details.

This topic describes how to designate a server to which Microsoft SQL Server forwards events in SQL Server by using SQL Server Management Studio . Note that event forwarding applies to events forwarded between servers, not to events forwarded between instances of SQL Server hosted on a single computer. Also note that in order to receive forwarded events, the alerts management server must be a default instance of SQL Server.

Before You Begin

Security

Permissions

Requires membership in the sysadmin fixed server role.

Using SQL Server Management Studio

To designate an events forwarding server

  1. In Object Explorer, click the plus sign to expand the server from which you want to forward events to another server.

  2. Right-click SQL Server Agent and select Properties.

  3. In the SQL Server Agent Properties -server_name dialog box, under Select a page, select Advanced.

  4. Under SQL Server event forwarding, select the Forward events to a different server check box.

  5. In the Server list, select a server, and then, under Events, select one of the following:

    • Select Unhandled events to forward only the events that have not been handled by local alerts.

    • Select All events to forward all events regardless of whether they have been handled by local alerts.

  6. In the If event has severity at or above list, click the severity level at which events are forwarded to the selected server.

  7. When finished, click OK.