# Alert: AlertErrorNumber

## Properties

Property | Value
--- | ---
Alert Name | AlertErrorNumber
ID | 5
Event Type | SQL Server event alert
Enabled |
Category Name | [Uncategorized]

## Definition

Property | Value
--- | ---
Event Source | MSSQLSERVER
Database Name | All Databases
Error Number | 1222
Raise alert when message contains | aaaa

## Response

Property | Value
--- | ---
Notification | E-Mail, Pager
Include alert event description in | E-Mail, Net Send
Additional notification message to sent | zzawsd test message
Delay Between Responses (mi:ss) | 00:10:20

## Occurances History

Property | Value
--- | ---
Last Occurance | Never Occured
Last Response | Never Responded
Occurrence Count | 0
Count Reset Date | Never Reset

## Notifications

Operator | Notification Method
--- | ---
krystian | Netsend

## SQL

Script
EXEC msdb.dbo.sp_add_alert @name=N'AlertErrorNumber', @message_id=1222, @severity=0, @enabled=1, @delay_between_responses=620, @include_event_description_in=5, @notification_message=N'zzawsd test message', @event_description_keyword=N'aaaa', @category_name=N'[Uncategorized]', @job_id=N'00000000-0000-0000-0000-000000000000'

#### See also

List of Alerts