alert to verify if sql server is up

[ersatz]

Hi,
How can I create an alert to test if the database is up?
I am beginner in sql server.
Thanks in advance,
ersatz

 

[mrdenny]

I'm not sure what you mean. Do you want to send an alert through your monitoring tool, or have SQL notify you that all is well?

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[ersatz]

Hi,

Thanks for your answer.
I want to receive an email when i have a problem with sql server.
Thanks again,
ersatz

 

[mrdenny]

What kind of problem do you want to get an alert for? SQL Server Agent can send alerts on hundreds of different problems. There are several default alerts setup that you can use.

The first thing you will need to do is setup emailing on the server. Use this FAQ to get that setup. faq962-4452

Denny

--Anything is possible. All it takes is a little research. (Me)