# Alert: test3

## Properties

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

## Definition

Property | Value
--- | ---
Event Source | MSSQLSERVER
Database Name | cart2
Severity | 9

## Response

Property | Value
--- | ---
Notification | E-Mail
Include alert event description in | E-Mail
Additional notification message to sent |
Delay Between Responses (mi:ss) | 00:00:00

## 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 | E-mail

## SQL

Script
EXEC msdb.dbo.sp_add_alert @name=N'test3', @message_id=0, @severity=9, @enabled=1, @delay_between_responses=0, @include_event_description_in=1, @database_name=N'cart2', @category_name=N'[Uncategorized]', @job_id=N'00000000-0000-0000-0000-000000000000'

#### See also

List of Alerts