May 2, 2012 at 12:46 pm
We have some mirrored databases in SQL SERVER 2008 and I have created some alerts(Like checking the state of mirrored database,...) for monitoring the mirroring system.Is there any way that we can repeatedly send notification email(like manual failover) every 1 min.
May 2, 2012 at 1:52 pm
You'd do that by setting up an SQL Agent job that runs every minute and uses sp_send_dbmail to send you the appropriate data.
Why would you want an e-mail every minute? You're not likely to have time to read all of them, much less do anything else except read them, at that frequency. The usual practice is just send an alert when something goes wrong, and leave it be when it's all working correctly.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply