/
CreateAgentAlerts_Ch08_CreateANewAlert.sql
138 lines (138 loc) · 3.89 KB
/
CreateAgentAlerts_Ch08_CreateANewAlert.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
USE msdb ;
GO
EXEC dbo.sp_add_notification
@alert_name = N'Alert Tester',
@operator_name = N'MyNewOperator',
@notification_method = 1 ;
GO
USE [msdb]
GO
EXEC msdb.dbo.sp_add_alert @name=N'Severity 017',
@message_id=0,
@severity=17,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1;
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 017',
@operator_name=N'MyNewOperator', @notification_method = 1;
GO
EXEC msdb.dbo.sp_add_alert @name=N'Severity 018',
@message_id=0,
@severity=18,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1;
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 018',
@operator_name=N'MyNewOperator', @notification_method = 1;
GO
EXEC msdb.dbo.sp_add_alert @name=N'Severity 019',
@message_id=0,
@severity=19,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1;
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 019',
@operator_name=N'MyNewOperator', @notification_method = 1;
GO
EXEC msdb.dbo.sp_add_alert @name=N'Severity 020',
@message_id=0,
@severity=20,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1;
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 020',
@operator_name=N'MyNewOperator', @notification_method = 1;
GO
EXEC msdb.dbo.sp_add_alert @name=N'Severity 021',
@message_id=0,
@severity=21,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1;
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 021',
@operator_name=N'MyNewOperator', @notification_method = 1;
GO
EXEC msdb.dbo.sp_add_alert @name=N'Severity 022',
@message_id=0,
@severity=22,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1;
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 022',
@operator_name=N'MyNewOperator', @notification_method = 1;
GO
EXEC msdb.dbo.sp_add_alert @name=N'Severity 023',
@message_id=0,
@severity=23,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1;
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 023',
@operator_name=N'MyNewOperator', @notification_method = 1;
GO
EXEC msdb.dbo.sp_add_alert @name=N'Severity 024',
@message_id=0,
@severity=24,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1;
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 024',
@operator_name=N'MyNewOperator', @notification_method = 1;
GO
EXEC msdb.dbo.sp_add_alert @name=N'Severity 025',
@message_id=0,
@severity=25,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1;
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 025',
@operator_name=N'MyNewOperator', @notification_method = 1;
GO
EXEC msdb.dbo.sp_add_alert @name=N'Error Number 823',
@message_id=823,
@severity=0,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1;
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Error Number 823',
@operator_name=N'MyNewOperator', @notification_method = 1;
GO
EXEC msdb.dbo.sp_add_alert @name=N'Error Number 824',
@message_id=824,
@severity=0,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1;
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Error Number 824',
@operator_name=N'MyNewOperator', @notification_method = 1;
GO
EXEC msdb.dbo.sp_add_alert @name=N'Error Number 825',
@message_id=825,
@severity=0,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1;
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Error Number 825',
@operator_name=N'MyNewOperator', @notification_method = 1;
GO
EXEC msdb.dbo.sp_add_alert @name=N'Error Number 833',
@message_id=833,
@severity=0,
@enabled=1,
@delay_between_responses=60,
@include_event_description_in=1;
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Error Number 833',
@operator_name=N'MyNewOperator', @notification_method = 1;