I'm wondering how to send an email if a data load fails. Or, do the same, if a Select > Into or Insert > Select . . . or whatever . . . fails. Last week I set up a process to send an email using SQL Server express.
http://www.sqlservercentral.com/blogs/querying-microsoft-sql-server/2013/09/02/sending-mail-using-sql-server-express-edition/
I can easily include a simple script at the end of a SQL statement:
Go to the complete details ...