USE [msdb]
GO

EXEC msdb.dbo.sp_add_alert @name=N'Severity 17', 
		@message_id=0, 
		@severity=17, 
		@enabled=1, 
		@delay_between_responses=10800, 
		@include_event_description_in=1, 
		@job_id=N'00000000-0000-0000-0000-000000000000'
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 17', @operator_name=N'OPERATORNAME', @notification_method = 1
GO

EXEC msdb.dbo.sp_add_alert @name=N'Severity 18', 
		@message_id=0, 
		@severity=18, 
		@enabled=1, 
		@delay_between_responses=10800, 
		@include_event_description_in=1, 
		@job_id=N'00000000-0000-0000-0000-000000000000'
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 18', @operator_name=N'OPERATORNAME', @notification_method = 1
GO

EXEC msdb.dbo.sp_add_alert @name=N'Severity 19', 
		@message_id=0, 
		@severity=19, 
		@enabled=1, 
		@delay_between_responses=10800, 
		@include_event_description_in=1, 
		@job_id=N'00000000-0000-0000-0000-000000000000'
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 19', @operator_name=N'OPERATORNAME', @notification_method = 1
GO

EXEC msdb.dbo.sp_add_alert @name=N'Severity 20', 
		@message_id=0, 
		@severity=20, 
		@enabled=1, 
		@delay_between_responses=10800, 
		@include_event_description_in=1, 
		@job_id=N'00000000-0000-0000-0000-000000000000'
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 20', @operator_name=N'OPERATORNAME', @notification_method = 1
GO

EXEC msdb.dbo.sp_add_alert @name=N'Severity 21', 
		@message_id=0, 
		@severity=21, 
		@enabled=1, 
		@delay_between_responses=10800, 
		@include_event_description_in=1, 
		@job_id=N'00000000-0000-0000-0000-000000000000'
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 21', @operator_name=N'OPERATORNAME', @notification_method = 1
GO

EXEC msdb.dbo.sp_add_alert @name=N'Severity 22', 
		@message_id=0, 
		@severity=22, 
		@enabled=1, 
		@delay_between_responses=10800, 
		@include_event_description_in=1, 
		@job_id=N'00000000-0000-0000-0000-000000000000'
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 22', @operator_name=N'OPERATORNAME', @notification_method = 1
GO

EXEC msdb.dbo.sp_add_alert @name=N'Severity 23', 
		@message_id=0, 
		@severity=23, 
		@enabled=1, 
		@delay_between_responses=10800, 
		@include_event_description_in=1, 
		@job_id=N'00000000-0000-0000-0000-000000000000'
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 23', @operator_name=N'OPERATORNAME', @notification_method = 1
GO

EXEC msdb.dbo.sp_add_alert @name=N'Severity 24', 
		@message_id=0, 
		@severity=24, 
		@enabled=1, 
		@delay_between_responses=10800, 
		@include_event_description_in=1, 
		@job_id=N'00000000-0000-0000-0000-000000000000'
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 24', @operator_name=N'OPERATORNAME', @notification_method = 1
GO

EXEC msdb.dbo.sp_add_alert @name=N'Severity 25', 
		@message_id=0, 
		@severity=25, 
		@enabled=1, 
		@delay_between_responses=10800, 
		@include_event_description_in=1, 
		@job_id=N'00000000-0000-0000-0000-000000000000'
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Severity 25', @operator_name=N'OPERATORNAME', @notification_method = 1
GO