O'Reilly logo

Tribal SQL by Matt Velic, David Tate, Shaun J Stuart, Wil Sisney, Mark S Rasmussen, Bob Pusateri, Dev Nambi, Colleen Morrow, Stephanie Locke, Chuck Lathrope, Tara Kizer, Kevin Feasel, Diana Dee, John Barnett, Dave Ballantyne

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Database Mail to Email Enable Your SQL Server

John Barnett

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required