DB Stored Procedure job goes in SUBERROR and completes on resubmit
The Database Plugin attempts to check if the pooled connection is still valid using isValid() method specified by JDBC 4.0.
It checks if the method exists and is not abstract.
Initial jTDS driver did not support the isValid() method in which case agent detected that appropriately and never attempts to call the 'isValid()' method. However, in later version (1.3.0 and above), jTDS seem to have added the public method and simply throws AbstractMethodError().
The following two steps will allow to run Stored Procedure jobs without going in to SUBERROR first.
1. Disable the connection pool.
Add the following parameter in agentparm.txt
(0 - disables DB connection pooling)
2. Use an older version of jTDS driver version such as 1.2.6 and 1.2.8