InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 08:25:24 GMT20http://www.sqlservercentral.com/Forums/Topic1224435-110-1.aspxI'm sure there is a better way. This was just fast to throw together.This assumes you have dbmail setup and a valid operator.Run this on the server you want to monitor:create database dbadmingouse dbadmingocreate table serverstatus (isawake char(1))GOinsert into serverstatusvalues(1)create a least privelidged login and a link server connection from your monitor to the monitoree with that account.Then throw this in a job stepDeclare @isawake char(1)set @isawake = (select isawake from [SERVERIWANTTOMONITOR].dbadmin.dbo.serverstatus)if @isawake <> '1'beginraiserror('Test Notify Server Failure', 16, 1, 1)endSet the notifications on the job to email the operator on failure. Also have a second server that points back to the monitor server to validate that is awake as well.Thu, 29 Dec 2011 16:29:38 GMTbenjamin.reyeshttp://www.sqlservercentral.com/Forums/Topic1224435-110-1.aspxPlease can you help I need a script that will use a centralized server to monitor other sql servers state and if a server is offline it will send a email to alert the dba about which server has a database that is offline . Pleaase do great assist and all your help is greatly appreciated.Tue, 20 Dec 2011 07:42:53 GMTbobnysoftz