The job of a DBA team is, in essence, to maintain a “steady ship,” ensuring that the database systems in their care are available, reliable and responsive. When problems do arise, the team must respond quickly and effectively. One of the keys to a fast response time is swift notification of problems as they arise and, for this purpose, we have a solution, Database Mail, built directly into SQL Server.
We can use Database Mail to:
• send email from T-SQL containing, for example, the results of a T-SQL statement and including reports and other necessary files as attachments
• report on the success or failure of SQL Server agent jobs
• provide a real-time notification system ...