- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi,
Create a workflow with at least these parts:
- Scheduler that runs every hour or whatever recipients are bucketed into
- Query that selects all recipients with time preference below next bucket start, for hourly this would be '@timePreferred before Hour(AddHours(GetDate(), 1) and delivery log does not exist where this delivery was attempted to recipient this cycle'. Safe and allows for 'catch up' as there isn't a lower bound
- Continuous delivery. If this is a workflow that runs on a recurring basis and should have a different delivery per cycle it gets slightly more complicated
Thanks,
-Jon