Create and manage SQL Agent jobs

Intermediate
Data Analyst
Data Engineer
Database Administrator
Azure
SQL Database
SQL Server

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

Learning 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.

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.