SQL Server Alerts

Posted on March 3, 2019 by cesmngin Monitoring

SQL Server default alerts for new server builds will help you identify critical issues in the system as soon as they occur.

The following scripts will create alerts for those critical events.

USE [msdb]
GO
EXEC msdb.dbo.sp_update_operator @name=N'DBA',
@enabled=1,
@pager_days=0,
@email_address=N'dba@dbasvc.com',
@pager_address=N'',
@netsend_address=N''
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Error Number 823', @operator_name=N'DBA', @notification_method = 1
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Error Number 824', @operator_name=N'DBA', @notification_method = 1
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Error Number 825', @operator_name=N'DBA', @notification_method = 1
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'ErrorLogMoreThan70Perecent', @operator_name=N'DBA', @notification_method = 1
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Severity 016', @operator_name=N'DBA', @notification_method = 1
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Severity 017', @operator_name=N'DBA', @notification_method = 1
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Severity 018', @operator_name=N'DBA', @notification_method = 1
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Severity 019', @operator_name=N'DBA', @notification_method = 1
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Severity 020', @operator_name=N'DBA', @notification_method = 1
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Severity 021', @operator_name=N'DBA', @notification_method = 1
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Severity 022', @operator_name=N'DBA', @notification_method = 1
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Severity 023', @operator_name=N'DBA', @notification_method = 1
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Severity 024', @operator_name=N'DBA', @notification_method = 1
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Severity 025', @operator_name=N'DBA', @notification_method = 1
GO