Create and manage SQL Agent jobs
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.