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,