• You should be able to set up the alert based on the scripts in that link. The alert can be set to generate the emails you need, and can also run another job which in turn can execute a stored proc to produce whatever information you want to save. You could look at sys.database_mirroring for the state of each database.