Create Alert from Script

Script created by SSMS.

Severity Alert

USE [msdb]
GO

EXEC msdb.dbo.sp_add_alert @name=N'Severity 016', 
		@message_id=0, 
		@severity=16, 
		@enabled=0, 
		@delay_between_responses=3600, 
		@include_event_description_in=1, 
		@category_name=N'[Uncategorized]', 
		@job_id=N'00000000-0000-0000-0000-000000000000'
GO

Error Alert

USE [msdb]
GO

EXEC msdb.dbo.sp_add_alert @name=N'Error 823', 
		@message_id=823, 
		@severity=0, 
		@enabled=0, 
		@delay_between_responses=3600, 
		@include_event_description_in=1, 
		@category_name=N'[Uncategorized]', 
		@job_id=N'00000000-0000-0000-0000-000000000000'
GO