软件下载吧文章资讯

分类分类

SQL开发知识:SQL Server Alert发送告警邮件少了的原因

2024-03-26 14:33作者:下载吧

最近突然发现我们部署在数据库上面的告警(Alert),当错误日志里面出现错误时,并不是每个错误日志都会发送邮件出来。如下所示,设置了告警“SQL Server Severity Event 14” 

USE [msdb]
GO

IF NOT EXISTS(SELECT 1 FROM msdb.dbo.syscategories WHERE NAME=’DBA_MONITORING’ AND category_class=2)
BEGIN

EXEC msdb.dbo.sp_add_category
@class=N’ALERT’,
@type=N’NONE’,
@name=N’DBA_MONITORING’ ;

END
GO

IF EXISTS(SELECT name FROM msdb.dbo.sysalerts WHERE name= N’SQL Server Severity Event 14′)

EXEC msdb.dbo.sp_delete_alert @name=N’SQL Server Severity Event 14′
GO

EXEC msdb.dbo.sp_add_alert @name=N’SQL Server Severity Event 14′,
@message_id=0,
@severity=14,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1,
@category_name=N’DBA_MONITORING’,
@job_id=N’00000000-0000-0000-0000-000000000000′
GO

EXEC msdb.dbo.sp_add_notification @alert_name=N’SQL Server Severity Event 14′, @operator_name=N’YourSQLDba_Operator’, @notification_method = 1
GO

展开全部

相关文章

说两句网友评论
    我要跟贴
    取消