Running a database job gives the error message: java.lang.ClassNotFoundException: com.microsoft.sqls

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Running a database job gives the error message: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Environment

Release: 21.0.x, 12.3.x
Component: AUTOMIC WORKLOAD AUTOMATION

Resolution

Detailed Description and Symptoms

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.

Investigation

?This message usually appears when the incorrect jdbc driver (or no jdbc driver) is in the jdbc directory for the agent.

Solution

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.