AE - Database Connect Strings in agentparm.txt
Article ID: 115434
Updated On:
Products
CA Workload Automation AE - Business Agents (AutoSys)
CA Workload Automation AE - Scheduler (AutoSys)
Workload Automation Agent
Issue/Introduction
Can the database agent be configured to have multiple database connection strings in the agentparm.txt file?
Environment
Product - Workload Automation AE 11.3.x
Platform - Windows, Unix/Linux
Databases - Oracle, SQL, Sybase, DB2
Platform - Windows, Unix/Linux
Databases - Oracle, SQL, Sybase, DB2
Resolution
There can be only one default database connect string per agentparm.txt file.
Users can run DB jobs against different databases by overriding the default connection string at the job level.
Another option is to install a second system agent, configure it with its own db plugin and specify a different database connection string.
See the following url for overriding the connection string at the job level:
https://docops.ca.com/ca-workload-automation-ae/11-4-2/en/reference/ae-job-information-language/jil-job-definitions/connect_string-attribute-specify-database-resource-location
Users can run DB jobs against different databases by overriding the default connection string at the job level.
Another option is to install a second system agent, configure it with its own db plugin and specify a different database connection string.
See the following url for overriding the connection string at the job level:
https://docops.ca.com/ca-workload-automation-ae/11-4-2/en/reference/ae-job-information-language/jil-job-definitions/connect_string-attribute-specify-database-resource-location
Feedback
Yes
No
Powered by
