SQL Job failing with ClassNotFoundeException

book

Article ID: 193325

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation CA Automic Operations Manager CA Automic Oracle

Issue/Introduction

The SQL job is failing with the below error message in the SQL agent's log.

2020-06-15 06:41:00 - U02000005 Job 'SQLJOBTEST' with RunID '79222153' started.
2020-06-15 06:41:00 - U02012031 The database driver returned the following error message:
2020-06-15 06:41:00 java.lang.ClassNotFoundException: com.sap.db.jdbc.Driver
2020-06-15 06:41:00 - U02004025 Job-script execution was aborted.

Cause

The jdbc driver is missing in the jdbc folder of the SQL agent. 

Environment

Release : 12.x

Component : AUTOMATION ENGINE, SQL Agent

Resolution

Please check if the jdbc driver is present as explained in the documentation below. Also, make sure the user has proper permissions in the jdbc folder.


JDBC for SQL agent