Alert: AlertErrorNumber Alert: AlertErrorNumber| Property | Value |
|---|---|
| Alert Name | AlertErrorNumber |
| ID | 5 |
| Event Type | SQL Server event alert |
| Enabled |
|
| Category Name | [Uncategorized] |
| Property | Value |
|---|---|
| Event Source | MSSQLSERVER |
| Database Name | All Databases |
| Error Number | 1222 |
| Raise alert when message contains | aaaa |
| 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 |
| Property | Value |
|---|---|
| Last Occurance | Never Occured |
| Last Response | Never Responded |
| Occurrence Count | 0 |
| Count Reset Date | Never Reset |
| Operator | Notification Method |
|---|---|
| krystian | Netsend |
| 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' |