Batch Macro should force stop if it fails during Iterations and should run the next steps

Question

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.

saiirangam · Answer

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.

apathetichell · Answer

This sounds like you want different queries in different macros and you want to rearchitect your process.