We want to send a mail with order information if an order has reached a certain status.
During the day the system should look out several times if an order has reached that particular status and as soon as that status has been reached, a report should be send per mail.
We cannot shedule this report each hour and send it to the end customer because then he will get reports with no information in it. We do not want that. We only want to send the report if the order is in status 60 for that particular customer, only then the customer is interested in knowing anything about that order.
How should we set up a shedule that the report is only send when this event is triggered.