Database Mail & Alerts

SQL 2016    |    Intermediate
  • 11 Videos | 1h 2m 58s
  • Includes Assessment
  • Earns a Badge
Likes 57 Likes 57
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

  • Playable
    1. 
    Database Mail
    7m 17s
    UP NEXT
  • Playable
    2. 
    Logs and Retention in Database Mail
    5m 29s
  • Locked
    3. 
    Configuring Database Mail
    9m 14s
    FREE ACCESS
  • Locked
    4. 
    SQL Server Agent
    5m 22s
    FREE ACCESS
  • Locked
    5. 
    SQL Server Agent Operators
    4m 43s
    FREE ACCESS
  • Locked
    6. 
    Creating a SQL Server Agent Operator Using SSMS
    5m 47s
    FREE ACCESS
  • Locked
    7. 
    SQL Server Agent Alerts
    4m 54s
    FREE ACCESS
  • Locked
    8. 
    Troubleshoot SQL Server Agent Alerts
    3m 33s
    FREE ACCESS
  • Locked
    9. 
    Creating SQL Server Agent Alerts
    4m 53s
    FREE ACCESS
  • Locked
    10. 
    Creating Alerts for User-Defined Events
    5m 54s
    FREE ACCESS
  • Locked
    11. 
    Defining Failure Actions
    5m 54s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Monitoring Queries
Likes 43 Likes 43  
COURSE Optimizing Statisitics & Indexes
Likes 26 Likes 26  
BOOK High Performance SQL Server: Consistent Response for Mission-Critical Applications, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Database Restoration
Likes 42 Likes 42  
COURSE Auditing
Likes 57 Likes 57  
COURSE Policy-based Management & Performance Monitoring
Likes 16 Likes 16