SQL Plugin with multiple targets

Products

• CA Workload Automation AE
• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation DE - Business Agents (dSeries)

Issue/Introduction

A user has one server, with two SQL Server 2019 instances. Both are using static ports, and port numbers and have been defined in the properties files.

When attempting to use the SQL Agent client to connect to both instances, the agent uses the second entry in the properties files and ignores the server information in the job.

Environment

Release : 11.x or 12.x

Component : Workload Automation System Agent

Resolution

If user intends to run SQL jobs on multiple non-related servers each SQL instance must have its own properties file.  

There cannot be duplicate keys/entris in the <targetdb>.properties file.

If MSSQL servers are part of the multi-server environment (master, target server), then create <targetdb>.properties and use the "sqlagent_server_name" to refer to the Targets defined in the SQL agent job.