Database Mail & Alerts

SQL 2016    |    Intermediate
  • 11 videos | 1h 2m 58s
  • Includes Assessment
  • Earns a Badge
Rating 4.1 of 29 users Rating 4.1 of 29 users (29)
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 17s
    Upon completion of this video, you will be able to describe Database Mail, mail profiles, and the importance of security. FREE ACCESS
  • 5m 29s
    Upon 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
  • Locked
    3.  Configuring Database Mail
    9m 14s
    In this video, you will learn how to configure Database Mail. FREE ACCESS
  • Locked
    4.  SQL Server Agent
    5m 22s
    Upon completion of this video, you will be able to recognize the features, benefits, and components of SQL Server Agent. FREE ACCESS
  • Locked
    5.  SQL Server Agent Operators
    4m 43s
    After 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
  • Locked
    6.  Creating a SQL Server Agent Operator Using SSMS
    5m 47s
    In this video, learn how to create a SQL Server Agent operator using SQL Server Management Studio. FREE ACCESS
  • Locked
    7.  SQL Server Agent Alerts
    4m 54s
    After 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
  • Locked
    8.  Troubleshoot SQL Server Agent Alerts
    3m 33s
    After completing this video, you will be able to recognize the troubleshooting process for SQL Server Agent alerts and notifications. FREE ACCESS
  • Locked
    9.  Creating SQL Server Agent Alerts
    4m 53s
    In this video, you will learn how to create SQL Server Agent alerts and configure their actions using SQL Server Management Studio. FREE ACCESS
  • Locked
    10.  Creating Alerts for User-Defined Events
    5m 54s
    During this video, you will learn how to create alerts that respond to user-defined events. FREE ACCESS
  • Locked
    11.  Defining Failure Actions
    5m 54s
    Find 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 Auditing
Book Database Performance at Scale: A Practical Guide
Journey Technical Program Management
Rating 4.6 of 7 users Rating 4.6 of 7 users (7)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Access & Permissions
Rating 4.6 of 86 users Rating 4.6 of 86 users (86)
Course SQL & Concurrency Concepts
Rating 4.6 of 245 users Rating 4.6 of 245 users (245)
Course Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group Functions
Rating 4.3 of 24 users Rating 4.3 of 24 users (24)