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 |
|
fqiao70
Yak Posting Veteran
52 Posts |
 Posted - 2003-06-13 : 18:11:07
|
| Hi, I want to create a alert or job to inform me by email immidiately when database goes down. how to do that????Thank you very much! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-13 : 18:17:39
|
| Well do you have SQLMail configured yet? That's the first step. The second step is to setup an alert. You need to figure out which error that you want to alert on. Severities 019-025 are probably what you want to alert on, but that part is up to you. Once you figure that part out, you need to configure the alert so that it send the e-mail to you.What we do here is we've got a monitoring web page that monitors various aspects of our environment. We have operators who watch the monitors and notify us of errors. It's important to have an outside process monitor as well because if your server goes down, you won't get e-mailed about it because the server can't e-mail you when it is down.Tara |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-06-13 : 23:49:57
|
| You will need to set up an operator (With your email address) as well.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
debug
Starting Member
29 Posts |
Posted - 2003-06-17 : 03:08:22
|
| Hi,In this scenario, an external third party monitoring software like NETIQ would be a best solution to implement.DU |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-17 : 07:30:07
|
| Why would paying for and installing an external tool be better than utilizing the tools that come with SQL Server at no extra charge? |
|
|
|
|
|
|
how to use alert to inform me when database down?