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 securitydescribe the logging levels and the need for a retention policy in Database Mailconfigure Database Mailrecognize the features, benefits, and components of SQL Server Agentdescribe the purpose of SQL Server Agent operators, the types of contact methods, and notificationscreate 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 dorecognize the troubleshooting process for SQL Server Agent alerts and notificationscreate SQL Server Agent alerts and configure their actions using SQL Server Management Studiocreate alerts that respond to user-defined eventsdefine 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.