I would like to unsubscribe from this idea.
I’m not talking about Agent alerts when jobs fail. That’s fine when you can’t get the business to spring for a monitoring system.
I’m talking about using SQL Server to send emails to confirm a customer’s order, alert that a product is low on stock, or other business processes.
SQL Server’s email delivery isn’t very robust. Whoever started the documentation by writing “Database mail is an enterprise solution” had clearly never seen an enterprise solution in real life. Sure, it seemed robust when it came out a couple decades ago, but these days, anything involving