Error message AWKDBE009E is received

Submission of an MSSQL job or of a Database job on an MSSQL database fails.

When you try to submit an MSSQL job or a Database job running on an MSSQL database, an error message similar to the following is returned, despite the required JDBC driver being installed in the correct directory: 
AWKDBE009E Unable to create the connection - "  
java.lang.UnsupportedOperationException: 
Java Runtime Environment (JRE) version 1.6 is not supported by this driver. 
Use the sqljdbc4.jar class library, which provides support for JDBC 4.0."

Cause and solution:

Verify that only the required sqljdbc4.jar driver is present in the JDBC driver directory. If unsupported JDBC drivers are also present in this directory, the dynamic agent might load them and cause the error message.
To solve the problem, perform the following steps:
  1. Remove the unsupported JDBC drivers.
  2. Stop the dynamic agent with command ShutDownLwa.
  3. Restart the dynamic agent with command StartUpLwa.

For more information, see the section about configuring to schedule job types with advanced options in IBM Workload Scheduler: Administration Guide.