SQL Plugin with multiple targets
search cancel

SQL Plugin with multiple targets


Article ID: 248216


Updated On:


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)


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.


Release : 11.x or 12.x

Component : Workload Automation System Agent


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.