Automated Administration Tasks (SQL Server Agent)

Applies to: yesSQL Server (all supported versions) YesAzure SQL Managed Instance

Important

On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details.

Microsoft SQL Server allows you to automate administrative tasks. To automate administration, you define predictable administrative tasks and then specify the conditions under which each task occurs. Using automated administration to handle routine tasks and events frees your time to perform other administrative functions.

In This Section

Implement SQL Server Agent Security

Implement Jobs

Monitor and Respond to Events

Automated Administration Across an Enterprise