Avatar

Level 6

You could build a workflow that will scan all the "production" workflows status and use api command like:

Restart (adobe.com)

You create a workflow with the query activity linked to a JS activity.

In the JS, you use a query def function with "vars.targetSchema" as schema declaration: it will select automatically the content of your previous query activity

Data oriented APIs | Adobe Campaign

 

Then you loop on the query result in order to execute your restart function

 

Netherless, you have a connection issue with the DB and your AC instance and you should spend time to investigate the root cause as restarting automatically workflows due to this problem is for having a better resilience while the issue is addressed