Skip to content

Instantly share code, notes, and snippets.

@petesql

petesql/enable_failsafe_operator.sql

Created September 28, 2017 08:56
Show Gist options
  • Save petesql/191af62038f08e1efae78e8d28ac26fa to your computer and use it in GitHub Desktop.
Save petesql/191af62038f08e1efae78e8d28ac26fa to your computer and use it in GitHub Desktop.
Download ZIP
Enable SQL Agent Fail-Safe Operator
Raw
enable_failsafe_operator.sql
USE [msdb]
GO
EXEC master.dbo.sp_MSsetalertinfo @failsafeoperator=N'YourOperator',
@notificationmethod=1
GO
USE [msdb]
GO
EXEC msdb.dbo.sp_set_sqlagent_properties @email_save_in_sent_folder=1
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment