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
-
7m 17sUpon completion of this video, you will be able to describe Database Mail, mail profiles, and the importance of security. FREE ACCESS
-
5m 29sUpon completion of this video, you will be able to describe the logging levels and the need for a retention policy in Database Mail. FREE ACCESS
-
9m 14sIn this video, you will learn how to configure Database Mail. FREE ACCESS
-
5m 22sUpon completion of this video, you will be able to recognize the features, benefits, and components of SQL Server Agent. FREE ACCESS
-
4m 43sAfter completing this video, you will be able to describe the purpose of SQL Server Agent operators, the types of contact methods, and the types of notifications. FREE ACCESS
-
5m 47sIn this video, learn how to create a SQL Server Agent operator using SQL Server Management Studio. FREE ACCESS
-
4m 54sAfter completing this video, you will be able to describe the purpose of SQL Server Agent alerts, how they are triggered, and what actions they can take. FREE ACCESS
-
3m 33sAfter completing this video, you will be able to recognize the troubleshooting process for SQL Server Agent alerts and notifications. FREE ACCESS
-
4m 53sIn this video, you will learn how to create SQL Server Agent alerts and configure their actions using SQL Server Management Studio. FREE ACCESS
-
5m 54sDuring this video, you will learn how to create alerts that respond to user-defined events. FREE ACCESS
-
5m 54sFind out how to define actions a SQL Server Agent should take in the event of a job failure. FREE ACCESS
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.YOU MIGHT ALSO LIKE
Channel
Database Performance Tuning