I have a list of subscribers inside a data extension. One of the fields is GamePoints. If a subscriber has more than 10 GamePoints I want to send an e-mail to remind them.
I am able to do this using the Automation Studio. This job will run every hour to check for subscribers with more than 10 GamePoints.
The problem is that once a subscriber reaches 10 GamePoints he receives an e-mail every time the job is running. But what I want is to limit this reminder per subscriber to only once every two weeks. Is this possible? (running the job only once per two weeks is not an option).