Iterative check on recurring workflow schedule

[Hermes1314]

Hi,

I am trying to build a workflow that does daily check on my data refresh. It is based on identifying a missing string in the dataset.

As a single run I have no problem and the email gets dispatched as needed, but as I would need this workflow to run every half an hour, I would like to send only one email, therefore making it stop sending emails for the rest day as soon as the first email is sent. Any idea on how I can perform such iterative check and stop the process?

Thanks in advance for the ideas!

[JoeS]

Hi @Hermes1314 

There are a few options, not sure which is best:

• Add the To email based upon a data field. Then configure a filter before to check for your condition, send the data away from the Email tool when you don't want to send an email. Then the email tool will have no To address to send it to.
• The Message tool. You should be able to configure it to error and stop processing records through.

There may be other ways, but hopefully one of the above will suffice.

[Christina_H]

It sounds like you need to record when an email gets sent so you can compare the next time the workflow runs.  I've updated the previous workflow I did for you to add this step.  There's a preliminary step to create a file to record the date.  When the workflow runs it checks the recorded date and only sends an email if the date is before the current date.  When an email is sent the date updates.