SQL Server DBA Tutorial 32 - How to Create an Alert in SQL Server

*****************************************************************************************
* How to Create an Alert in SQL Server *
*****************************************************************************************

Events are generated by SQL Server and entered into the Microsoft Windows application log. SQL Server Agent reads the application log and compares events written there to alerts that you have defined. When SQL Server Agent finds a match, it fires an alert, which is an automated response to an event. In addition to monitoring SQL Server events, SQL Server Agent can also monitor performance conditions and Windows Management Instrumentation (WMI) events.

To define an alert, you specify:
-The name of the alert.
-The event or performance condition that triggers the alert.
-The action that SQL Server Agent takes in response to the event or performance condition.

Alert in SQL Server
1. Types of the Alert
2. Severity
3. Message Search Settings
4. Response
5. Alert Options

/**** T-SQL Script to Create Alert in SQL Server ***/
USE [msdb]
GO
@message_id=0,
@severity=10,
@enabled=1,
@delay_between_responses=1800,
@include_event_description_in=1,
@notification_message=N'Job failed on Production System',
@event_description_keyword=N'Job Failed',
@job_id=N'00000000-0000-0000-0000-000000000000'
GO

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link :

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.