Schedule tasks using SQL Server Agent

Schedule tasks using SQL Server Agent

Explore SQL automation for scheduled tasks, and automatic alerts for SQL Server and Azure SQL Managed Instance.

Data Analyst
Database Administrator
Data Engineer
Azure
SQL Server
SQL Database

Module Objectives

After completing this module, you will be able to:

  • Schedule necessary maintenance activities for your databases.
  • Configure notifications and alerts on SQL Server Agent jobs, and SQL Server.
  • Configure alerts based on performance monitor values.

Units

Prerequisites

  • Ability to use tools for running queries against a Microsoft SQL Server database, either on-premises or on cloud.
  • Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
  • Experience creating, and configuring resources using the Azure portal.