I have scenario where I have created a batch macro to run set of SQL queries in sequence, but if in case if my second Iteration fails, then macro should not run the third instance. right now, it runs through all the Iterations and then the workflow results in the error at the end of the workflow which is taking more than 4 hours.
It should stop running the rest of the Iterations and trigger an email if any Iteration fails in between.
any workaround to fix this issue is highly appreciated.
This sounds like you want different queries in different macros and you want to rearchitect your process.
right now, I am creating each row for each query and sending those one after another in sequence into macro to execute. Please let me know if any workaround.