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

In this video you will learn how to create alert in SQL Server using SQL Server management studio as well using T-SQL Script. It walks you through different types of Alerts in SQL Server, how to configure severity settings, how to configure error message search, how to configure Response and configuring different options while creating alert in SQL Server. It also talks about best practices of creating SQL Server Alert using SQL Server Agent.

Blog post link for this video:

Visit our website to check out SQL Server DBA Tutorial Step by Step

[jeroenalblas]

Hi, at 5:50 - On the response tab, I guess you can run a specific job whenéver your alert fires. This has nothing to do with the cause of alert (or a specific job that caused it). Also, from the Alert tab within a job, you can create systemwide alerts which trigger the specific job you are currently editing. I guess you can use this like: If the alert "Low on disk space" fires than start the Job "Panic" which in step 1 removes your complete mp3 collection, and in step 2 cleans the transaction log or something.. ;)

[luffyy]

I don't understand what is the use of alert. I was able to send mail by creating just operator.

[olasimanyak]

Hi TechBrothers,
How can we set the threshold of the drive? I mean to prevent the drive to be fully occupied by the database data and logs. I hope you get my question.

Thanks,
Raph

[krishnatraveller]

Please make one video how to create the disk space alert in ms SQL server