Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
In Object Explorer, select the plus sign to expand the server from which you want to forward events to another server.
Right-click SQL Server Agent and select Properties.
In the SQL Server Agent Properties - <server_name> dialog box, under Select a page, select Advanced.
Under SQL Server event forwarding, select the Forward events to a different server check box.
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.
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.
When finished, select OK.