Verify Agent DB Plugin is Configured for MS SQL

Products

• Workload Automation Agent

Issue/Introduction

Installed the database plug-in today but having difficulty running a DB job successfully.

Environment

CA Workload Automation Agent for Databases
CA Workload Automation EE (ESP Edition)

Cause

The DB_MON job is failing with the SQL database exception like below;
java.sql.SQLException: No suitable driver found for xxxxxxxxxx.xxxxxx.com,3232
 

Resolution

The DB_URL specified in the job definition is not a valid database URL. The format of the DB_URL statement should be as below;
For Microsoft SQL Server database:
DB_URL 'jbdc:sqlserver://host:port;DatabaseName=dbname'

Notes:
- Ensure that the database driver JAR files for your SQL Server database are in the <Agent_Installdir>/jars/ext directory.
- The jdbc.drivers property in the agent's agentparm.txt file should include the database driver type.
Example:
jdbc.drivers=oracle.jdbc.driver.OracleDriver:net.sourceforge.jtds.jdbc.Driver