I have a scenario where I need to send email to owner of the account when it is locked. I want to run the query for every 5mins checking for last1 hr data, and the email should be sent only once in a day even the account is locked multiple times in a day. And the email configuration is done in the query itself, passing owner field values to email address.
As we cannot use throttling in this case(as mail is being sent from search query), could anyone please suggest a solution?