Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
craigwg
Posting Yak Master
154 Posts |
 Posted - 2010-02-15 : 12:36:09
|
| I need to alert a client via email when his database(s) come online. I was looking at SQL alerts but don't see a way to make this happen. I just need to automate it so that an operator receives an email when his database comes online. It would only be offline for monthly maintenance and he wants to know the moment it is available again.Ideas?Craig |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-15 : 13:15:36
|
| I expect there is something in SQL Server, but we use Servers Alive to check when our servers are Up / Down, and that has a specific SQL test for "Visible" / "Offline" and might make the basis of such a solution?Free for up to 10 servers-tested I think. |
 |
|
|
|
|
|
SQL Alerts