In Journey Builder you can set the contact entry rule 'No re-entry'. Is there a way to set up something similar with a non-journey builder automation?
I have an automation running hourly. I'd like to set the update method on my query to 'update', have new records added to my data extension, and then have the automated email only deploy to records newly added to the data extension (those who haven't been sent the email).
Is this possible and if so is there a setting I am missing or can this be done in SQL?