January 17, 2012 at 6:14 am
I am new in SQL and I want to know the reason enable SQL db Mail on the server(s).
Thanks in Advance.
🙂
January 17, 2012 at 6:52 am
If you turn it ON, you can send mail from SQL Server.
If you leave it OFF, you can't.
😛
No seriously, it's a very vague question. Is there anything in particular you want to know?
-- Gianluca Sartori
January 18, 2012 at 7:39 am
this way you can send alerts and results from queries. An example of the way I have used this in the past. I had a SQL Server that was processing data all day from customers that were sending it to us. If we fell behind by 15 minutes we were missing an SLA. So every 5 min. I would run a query to see how old the oldest record to be processed was. If it was older than 5 min, alerts would go out to everyone on the IT Team.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply