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
-
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
-
3. Configuring Database Mail9m 14sIn this video, you will learn how to configure Database Mail. FREE ACCESS
-
4. SQL Server Agent5m 22sUpon completion of this video, you will be able to recognize the features, benefits, and components of SQL Server Agent. FREE ACCESS
-
5. SQL Server Agent Operators4m 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
-
6. Creating a SQL Server Agent Operator Using SSMS5m 47sIn this video, learn how to create a SQL Server Agent operator using SQL Server Management Studio. FREE ACCESS
-
7. SQL Server Agent Alerts4m 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
-
8. Troubleshoot SQL Server Agent Alerts3m 33sAfter completing this video, you will be able to recognize the troubleshooting process for SQL Server Agent alerts and notifications. FREE ACCESS
-
9. Creating SQL Server Agent Alerts4m 53sIn this video, you will learn how to create SQL Server Agent alerts and configure their actions using SQL Server Management Studio. FREE ACCESS
-
10. Creating Alerts for User-Defined Events5m 54sDuring this video, you will learn how to create alerts that respond to user-defined events. FREE ACCESS
-
11. Defining Failure Actions5m 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.
