CA WA Agent for Microsoft SQL Server

Introduction › CA WA Agent for Microsoft SQL Server

CA WA Agent for Microsoft SQL Server

The CA WA Agent for Microsoft SQL Server lets you integrate with SQL Server Agent, a component of Microsoft SQL Server, to automate administrative database tasks.

The CA WA Agent for Microsoft SQL Server lets a user perform the following tasks:

Submit and monitor the status of SQL Server Agent jobs including Transact-SQL scripts, SQL Server Integration Services (SSIS) packages, or Replication tasks
Retrieve a list of jobs on a given Microsoft SQL Server Agent
Cancel a running job
Read the job log to diagnose errors
Get the spool output for a given job or job step

The following diagram shows the functional relationship between the scheduling manager, the CA WA Agent for Microsoft SQL Server plug-in, and the Microsoft SQL Server:

This diagram shows the functional relationship between the scheduling manager, the CA WA Agent for Microsoft SQL Server plug-in, and Microsoft SQL Server.