Search before asking

• I had searched in the issues and found no similar issues.

What happened

When a jdbc connection is closed, the job will still use the closed connection

What you expected to happen

When the connection is not available, the job continues to run after reacquiring the connection.

How to reproduce

Start a sqlserverCdc job and manually kill the connection on the server

SELECT conn.session_id, host_name, program_name, nt_domain, login_name, connect_time, last_request_end_time FROM sys.dm_exec_sessions AS sess JOIN sys.dm_exec_connections AS conn ON sess.session_id = conn.session_id;
KILL 'session_id'

Anything else

No response

Version

master

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct