Using jira automation I have done the following:
Your rule looks solid, I would do the same, and leave uncheck "Only include issues that have changed since the last time this rule executed" option. If you go on the trigger, it will guide you on when the rule is going to run for the very first time, as well as all the next runs. Keep in mind that if the JQL yields no results, then no email is going to be sent out.
However you could also use subscription filter instead of an automation:
Hope that helps!
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events