Database Mail & Alerts
SQL 2016
| Intermediate
- 11 videos | 1h 2m 58s
- Includes Assessment
- Earns a Badge
Regularly monitoring SQL Server instances helps identify and correct issues before they cause damage and can aid in performance tuning. Explore the creation and management of operators and SQL Server Agent alerts.
WHAT YOU WILL LEARN
-
describe Database Mail, mail profiles, and the importance of security
describe the logging levels and the need for a retention policy in Database Mail
configure Database Mail
recognize the features, benefits, and components of SQL Server Agent
describe the purpose of SQL Server Agent operators, the types of contact methods, and notifications
create a SQL Server Agent operator using SQL Server Management Studio -
describe the purpose of SQL Server Agent alerts, how they are triggered, and what they can do
recognize the troubleshooting process for SQL Server Agent alerts and notifications
create SQL Server Agent alerts and configure their actions using SQL Server Management Studio
create alerts that respond to user-defined events
define actions a SQL Server Agent should take in the event of job failure
IN THIS COURSE
-
1.Database Mail7m 17sUP NEXT
-
2.Logs and Retention in Database Mail5m 29s
-
3.Configuring Database Mail9m 14s
-
4.SQL Server Agent5m 22s
-
5.SQL Server Agent Operators4m 43s
-
6.Creating a SQL Server Agent Operator Using SSMS5m 47s
-
7.SQL Server Agent Alerts4m 54s
-
8.Troubleshoot SQL Server Agent Alerts3m 33s
-
9.Creating SQL Server Agent Alerts4m 53s
-
10.Creating Alerts for User-Defined Events5m 54s
-
11.Defining Failure Actions5m 54s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
