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: 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