Business Case: When a web store Sales Order is received where the AVS does not match the issuing banks billing information, we would like to send an email almost immediately. We want the AVS email to get to the customer just after the Sales Order confirmation email.
What is the best practice for something like this?
Concerns:
1) 100% beforeSubmit would work find but it seems best to minimize any code which could impact the sales order from being written to the database.
2) beforeSubmit scheduling a scheduled script would work but I worry that I will some how not create enough deployments.
3) 100% schedule script and have a deployment called every 15 minutes all day long. This seems the safest but calling the script 96 times per day when there may not be orders seems like a waste.
My inclination is to go with #2 and do a great job on error control.
Any thoughts would be appriciated.