What is a one sentence summary of your feature request?
Add a longer delay between retry attempts to reduce failures caused by transient SQL connection errors.
Please describe your idea in detail. What is your problem, why do you feel this idea is the best solution, etc.
During processing tasks, transient SQL connection errors can occasionally occur due to temporary network issues. The current retry logic immediately performs two retries in quick succession (less than one second apart), which often fails to mitigate the issue:
Microsoft.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 2 - Connection was terminated)
Add a longer delay between retry attempts would increase the likelihood of a successful reconnection when a transient issue is involved.
How do you currently solve the challenges you have by not having this feature?
It is necessary to restart the job execution manually.