From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Create and configure database tasks using automation

Create and configure database tasks using automation

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Create and configure database tasks using automation

“

- Welcome back. This is lesson 12.2, Create and configure database tasks Using automation. Azure automation is one of the available options we mentioned back in lessons 9.1, 9.2, and 9.3 when discussing how to automate maintenance tasks in Azure SQL database. SQL server maintenance tasks allow you to do things like index and statistics maintenance, as well as database integrity checks and database backups. While those work great in SQL Server in a virtual machine, maintenance tasks aren't available in Azure SQL Database. But those same lessons, we discussed the available options for performing index and statistics maintenance and database integrity checks, including Azure Automation. Azure Automation is an Azure service that really encapsulates three key tenets for supporting management that span your Azure and non-Azure environments. The first is process management, and process management is the component that lets you automate frequent management and maintenance tasks. And this is…

Contents