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?