I have an automation that runs periodically and email campaign begins with the data in a data extension.
In last step of my automation, i cam deleting the records in the data extension so that processed records do not come back again in next cycle of the automation.
But sometimes there is a situation in which there is no new data in the data extension to process but automation still triggers because it is a scheduled automation. Hence, I get error that data extract failed and automation failed.
Is there any way to ONLY run the automation when there are 1 or more records in a data extension. If data extension is blank then skip the automaton.
Best Answer
There is a new Verification Activity in Automation Studio. You can set this to verify if there are no subscribers in DE then stop the automation. This will prevent the error.