The CA WA DE (DE) has SQL and Stored Procedure (SP) job types. The jobs allows users to connect to different DB using the DB URL field.
The DB URL field can have a URL to the database that may be different from the one defined in the agentparm.txt. The new DB must be on the same host.
When installing the Database plugin, it will take default values for DB, user and password. They are entered in agetnparm.txt and used by agent if job does come with them from the scheduler (manager).
CA Workload Automation DE 11.3, R12.x
CA Workload Automation Agent for Databases 11.3, 11.4
Complete the following field (screenshot) if an SQL or SP job requires connection to a new or different database than the default (in agentparm.txt).
Note: You cannot define a different Database type.
E.g. If the database plugin was installed to connect to Oracle DB, then the new DB URL field must point to an Oracle DB on the same host or cluster. You cannot specify MS-SQL or any other database type.