Alert: JobAlert Alert: JobAlert| Property | Value |
|---|---|
| Alert Name | JobAlert |
| ID | 4 |
| Event Type | SQL Server event alert |
| Enabled |
|
| Category Name | [Uncategorized] |
| Property | Value |
|---|---|
| Event Source | MSSQLSERVER |
| Database Name | All Databases |
| Severity | 1 |
| Property | Value |
|---|---|
| Job Name | CMDJob |
| Notification | No Notifications |
| Include alert event description in | No Notifications |
| Additional notification message to sent | |
| Delay Between Responses (mi:ss) | 00:00:00 |
| Property | Value |
|---|---|
| Last Occurance | Never Occured |
| Last Response | Never Responded |
| Occurrence Count | 0 |
| Count Reset Date | Never Reset |
| Script |
|---|
| EXEC msdb.dbo.sp_add_alert @name=N'JobAlert',
@message_id=0,
@severity=1,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=0,
@category_name=N'[Uncategorized]',
@job_id=N'0acd1be8-c27b-401e-80ba-0df701ff4e9f' |