How to rerun workflow after "transient" connection error

[stefjaro]

Hi Community,

I'm currently stuck in the following situation: I have planned workflows with the scheduler to make copies of data from an azure server to local databases (yxdb). The problem is that the connection regularly drops and prevents data transfer. I checked the connection to the server with Microsoft and everything is ok apparently! So they advise me to program a "retry" in Alteryx. This is where I need your help because it is beyond my skills :(

I already tried the following without any success:
- using events together with AlteryxEngineCmd.exe

- trying to build iterative macro... 

Any advise on how to manage it?