com.microsoft.sqlserver.jdbc.SQLServerException: Connection timed out (Read failed)
Hello All, I have created an ETL job which will load data from SQL server 2012 to Azure SQL Server. All the data from source will be fetched and inserted into destination. I am running multiple jobs in parallel. I am facing the below error. When anyone of the job fails due to this, all the other jobs running in parallel also fails due to read time out. com.microsoft.sqlserver.jdbc.SQLServerException: Connection timed out (Read failed) 1. How to increase the timeout?. Is there a way to increase timeout for each query? 2. How to prevent other jobs/queries failing when one job/query fails? Thanks,