Transient error handling in Azure

[maayandermer]

Hi,

Recently I started to have some kind of weird error in my ETL processes. After investigating it with Microsoft support I ended up here:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-issues

Apparently in Azure SQL Server encountering transient errors is ok (?!?) due to maintenance issues. 

Can you share you best practices for restartibility of Jobs/components in a job? For example how would you manage a retry-restart of a whole map?

Maayan

[Anonymous]

Hello,

You can start Job from tLoop or tInfiniteLoop and finish with tSleep component.

Have you tried to setup Job schedule to see if it is OK with your use case?

Best regards

Sabrina

[maayandermer]

Hi @xdshi.

Thanks for the reply. We manged create the logic you suggested and it is working. We also added tChronometer for timeouts in case it gets hanged.

Thanks!

[Anonymous]

Hello,

Great it helps. Thanks for your prompt reply.

Best regards

Sabrina