How to wait a step to finish before start another one (SQL scritping)

Get Help & Discuss Process Studio
1

Hello,

I need to run some SQL scripts, and some of them depends of the results of others. I need to run a SQL, wait to finish, verify if run correctly (if copy all lines, etc) and then run the others scripts.

all the steps run in parallel… I need some run one aftter other…

Thank you!!!

1 Like
2

Hi! Jansen

You can put the second SQL Script in a child workflow using the Workflow Executor steps. You can configure the Workflow Executor step to pass the rows one by one to the child workflows. The default configuration is to pass one row at a time.

Secondly, you can place the second SQL Script in a loop between Start Loop-Continue Loop steps to pass rows one by one.

1 Like
3

Hi Semma,

thank you!!! I’ll try it!!

Best regards!!!

2 Likes