CA Workload Automation DE SQL or SP job type connect to different DB?

Document ID : KB000095908
Last Modified Date : 15/05/2018
Show Technical Document Details
Introduction:
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).

Example:
communication.alias_1=MYAGENT_DB
db.connectionPool.maxSize=5
db.default.password=d41d8cd98f00b204e9800998
db.default.url=jdbc:sqlserver://dbserver.example.com:1433;DatabaseName=NewDB
db.default.user=NewDBuser

 
Environment:
CA Workload Automation DE 11.3, R12.x
CA Workload Automation Agent for Databases 11.3, 11.4
Instructions:
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).
SQL Job
 
Additional Information:

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.