So far you were very helpful and I really appreciate that!
I'm a new user of Adobe Campaign Classic and I'm facing a problem with some of my workflows.
Some of the workflows I made stops from running because of an error ; ORA-210000 (timeout occurred)
The problem is not due to our database since it's running and there's no issue with it.
My question is, is there any workflow I can build that can restart the workflows that stop from running, please?
You could build a workflow that will scan all the "production" workflows status and use api command like:
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
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