Create and manage SQL Agent jobs
Explore SQL automation for scheduled tasks, and automatic alerts for SQL Server and Azure SQL Managed Instance.
Data Analyst
Data Engineer
Database Administrator
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.