Manage SQL Server Agent

Introduction

The Manage SQL Server Agent module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

• Create, Maintain, and Monitor Jobs
• Automate (Setup, Maintenance, Monitoring) Across Multiple Databases and Instances

Lab time: It will take approximately 1 hour to complete this lab.

Exercise 1 - Create, maintain, and monitor Jobs

In this exercise, you will perform the tasks required to manage SQL Server Agent.

Exercise 2 - Automate (Setup, Maintenance, Monitoring) Across Multiple Databases and Instances

You can use a single SQL Server Agent to monitor multiple instances of SQL Servers that are either on the same server or across multiple physical servers.