July 24, 2009 at 11:37 am
How do I setup a failover cluster alert using dbmail?
July 24, 2009 at 2:53 pm
I poll our clusters, connecting using the clustername, if the physical node changes that the cluster is running on I get an email. Run the script and punt to a table, have one table be how the physical node is now, say node X and then compare to another table of the next poll, if it changes send the alert and overwrite the record in now table.
I got the script from here a while back:
create table #Host (
id tinyint identity(1,1),
Ping_Txt varchar(255))
Insert #Host (Ping_Txt)
exec master.dbo.xp_cmdshell 'ping localhost -n 1'
select @@servername, upper(substring(Ping_Txt,9,charindex('[',Ping_Txt)-10)) as Host,
Ping_Txt from #Host where id=2
drop table #Host
July 24, 2009 at 3:13 pm
I found another way to do this.
1. Create a sql server agent job
2. Put an email message to yourself or your dba group in step #1
3. Put a schedule to start when sqlserver agent starts.
4. Put a pager notification on this job.
This is the way Microsoft recommended me to do it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply