Edit

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 T-SQL differences from SQL Server or SQL Agent job limitations in SQL Managed Instance for details.

This article describes how to designate a server to which SQL Server forward events by using SQL Server Management Studio.

Event forwarding applies to events forwarded between servers, not to events forwarded between instances of SQL Server hosted on a single computer. To receive forwarded events, the alerts management server must be a default instance of SQL Server.

Permissions

Requires membership in the sysadmin fixed server role.

Use SQL Server Management Studio

  1. In Object Explorer, select 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. Under Events, select one of the following options:

    • Select Unhandled events to forward only the events that local alerts don't handle.

    • Select All events to forward all events regardless of whether local alerts handle them.

  6. In the If event has severity at or above list, select the severity level at which you want to forward events to the selected server.

  7. When finished, select OK.