We've got a mirrored database on one of our servers and there's a mirrored database monitoring job set up.
As far as I can see, all it does it write data to a table.
Now, I've got a couple of questions:-
Can I set this job up to email if the originating mirror goes down? If so, has anyone got any pointers? The job runs every minute but I don't want to get bombarded with emails if it does (every 15 minutes will be plenty).
I can see the table in the MSDB database, but I'm not sure what the "Status" field is for. Anyone got any useful links as I'm obviously not searching the correct terms on Google?
I know the originating mirror went down yesterday (it was rebooted), but I can't see any evidence of that for the correct time-frame?
Anyone any pointers on reading the dbm_monitor_data table please?