Is there any way to queue SMS messages in Journey Builder after the blackout period has ended?

The only way I can think of is

  1. to run a SQL query to flip a boolean flag before the blackout time and
  2. update another column with the date/time when the blackout is over.
  3. Then use a Decision Split to evaluate that flag and
  4. finally a Wait Until activity to send the SMS message when the blackout is over.

Are there any other alternatives? RaiseError or Exclusion Scripts aren't available in MobileConnect and won't queue messages.

  • How would you join your 'controller' data extension to your data model in order to filter based on the blackout boolean? I'm only able to evaluate journey or contact data in a decision split - this wouldn't be either. May 17, 2021 at 19:45
  • Why wouldn't you be able to use journey or contact data? The query can update the journey DE or DE added to the Contact Data (preferred). If you go with the former, you'd have to add them to the Contact Data regardless since JB takes a snapshot of the data at entry. May 17, 2021 at 19:53
  • are you flipping a boolean flag on all contact records in your sendable data extension? My journey has an API entry point so records can be added to the sendable data extension and sent out at any time of day. I'm not clear on how I'd 'catch' new records before they send out to update the boolean (blackout = true). May 17, 2021 at 20:12
  • I had a second DE as Contact Data with the same primary key as the SubscriberKey. The data was queried from that entry DE and into this lookup DE. The Wait Until and Boolean fields lived in this lookup DE. May 17, 2021 at 21:11
  • ah - so you had to set the black-out for each subscriber. My process includes API initiation of SMS send with new subscribers being added via these API requests. I wouldn't be able to pre-set any black-out logic at the subscriber level. May 18, 2021 at 14:36

1 Answer 1


So I was able to test my own solution and it worked properly. The only thing I would add is that I added another query after a Wait period of 12 hours (or however long the blackout period is) and flipped the boolean flags back to indicate the blackout time is over. Also in the query, I cleared the date/time column if the blackout flag is false.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .