Running a database job gives the error message: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
Release: 21.0.x, 12.3.x
Component: AUTOMIC WORKLOAD AUTOMATION
Attempting to run a job on a database agent for MSSQL aborts and returns the error messages in the agent log:
U2012031 The database driver returned the following error message:
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
U2004025 Job-script execution was aborted.
PLEASE NOTE: These messages only occur if the "Agent log" option is selected in the SQL tab of the job.
?This message usually appears when the incorrect jdbc driver (or no jdbc driver) is in the jdbc directory for the agent.
To resolve this error message, be sure that the correct jdbc driver for the agent is in the \bin\jdbc\ directory for the ?database agent. JDBC drivers can be found from the database manufacturer. The Automic documentation has a place to start. This can be found under Administration Guide, Installation, New Installation, Installation Procedure, Installing the Agents, Installing the Agent for Databases, Installing the Agent for Database Jobs and Events, step 3.