Avatar

Correct answer by
Community Advisor

Hi,

 

Create a workflow with at least these parts:

  1. Scheduler that runs every hour or whatever recipients are bucketed into
  2. 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
  3. 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

View solution in original post