July 9, 2009 at 7:11 am
Hi friends,
I have to check my Sql Server databases are online or not as part of my daily Server monitoring.
I am checking this by logging into each and every server.
but our requirement is we need get alert when the database is offline/down.
that means a script which will ping/ check the state of the database on repititive intervals.
Can anyone please help me for this script.
thanks,
mohan
July 9, 2009 at 7:48 am
You can query sys.databases to see if a database in online or not and then use sp_senddbmail to sendo ut a message or you can write an error out and create an alert based on that error.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply