Our owner would like a automated text message sent to his phone every 30-60 minutes with total daily sales.
If we create a query and have it run every 60 minutes, and the query results sent via SQL Mail, that should do the trick.
What are the tables housing current daily sales totals?