The things I'd worry about with failover is strange behavior, or sending dup alerts. Maybe you read some data from master/msdb and load this into a table in your db, then process it?