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 |
|
joanne
Starting Member
46 Posts |
 Posted - 2004-09-28 : 08:15:24
|
| Hi, How can I create an alert to test if the database is up?I am beginner in sql server.Thanks in advance,joanne |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-28 : 08:45:16
|
alert where? and what do you mean by up?Go with the flow & have fun! Else fight the flow  |
 |
|
|
joanne
Starting Member
46 Posts |
Posted - 2004-09-28 : 19:07:28
|
| i want to create a job witch verify at every 30 minutes if sql server is upthanks again,joanne |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-28 : 19:09:57
|
| If SQL Server is not up, then you can not alert about it. Alerting from SQL Server is inside SQL Server. So if the service is stopped, you are screwed on the alert.You'll need to check the status of the MSSQLSERVER service. We use MOM and other 3rd party tool to check the status of SQL Server.Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-28 : 19:48:33
|
| I have a monitor server set up to check all the other servers and alert if anything is wrong. It just runs a load of jobs.At some point I must set up a job on another server to check the monitor.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-09-30 : 18:25:54
|
| Perhaps you could do the opposite and alert while the server is running, so that if the alerts stop you know there is a problem. Doubt if its ideal thoughsteveSteve no function beer well without |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-10-01 : 11:06:30
|
| You could use MOM or something to alert you of this. Have you looked into that?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
create an alert