Installed the database plug-in today but having difficulty running a DB job successfully.
CA Workload Automation Agent for Databases
CA Workload Automation EE (ESP Edition)
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
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:
- 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.