Apr 13 2022 08:24 AM
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.
Apr 18 2022 10:12 PM
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:
Notes:
1- You need to have Database Mail configured first;
2- You also need to have an operator configured.