Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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!
Hello,
Great it helps. Thanks for your prompt reply.
Best regards
Sabrina