SQL Server 2019 on Linux, Is there any way to enable the fail safe operator?

Copper Contributor

Is there any way to set the fail safe operator? Right clicking on SQL Agent and enabling through the GUI results in a fatal error. As does using sp_MSsetalertinfo - looks like it sets a registry key which wouldn't exist in linux. I haven't been able to find a mssql-conf set option. 

1 Reply

@Kibo_Jay_Zmudka 

A fail-safe operator is a backup user who receives the alert if the designated operator cannot be reached.

It will be used when SQL Server Agent cannot communicate with the system tables in the MSDB database.The fail-safe operator will also receive notifications if you have scheduled operators to only receive notifications during certain periods and notification occurs outside of that range.

 

Microsoft’s best practices recommend designating a fail-safe operator. You can do using SQL Server Management Studio by fallow the steps below:

  1. In Object Explorer, click the plus sign to expand the server that contains the SQL Server Agent operator that you want to designate as a fail-safe.
  2. Right-click SQL Server Agent and select Properties.
  3. In the SQL Server Agent Properties, under Select a page, select Alert System.
  4. Under Fail-safe operator, select Enable fail-safe operator.
  5. In the Operator list, select the operator that you want to make a fail-safe.
  6. Select either any or all of the following checkboxes to specify how the operator will be notified: E-mail, Pager, or Net send.
  7. When finished, click OK.

Notes:

1- You need to have Database Mail configured first;
2- You also need to have an operator configured.