SQL Job failing with ClassNotFoundeException

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic Workload Automation - Automation Engine

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