PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

Scheduling SQL Server backups by using SQL Server Agent

The SQL Server Agent is a job-scheduling agent which is contained in the Microsoft SQL Server package.

This section describes how to schedule SQL Server backups by using the SQL Server Agent job for the CmdExec and T-SQL subsystems. The SQL Server Agent, a job-scheduling agent within the SQL Server package, consists of a Windows service that runs jobs.

Each job can contain one or more job steps and each step can contain its own tasks. The Microsoft application agent uses SQL Server to store job information and can run jobs on a schedule in response to a specific event or in response to a specific demand.