Ability to automate e-mailing different groups or people with DB Heath Check results from different databases
When using Automation Designer to run multiple DB Health Checks for different databases, is it possible to have each database's DB Health Check results emailed to different group of people?
This can be done by setting up each DB Health Check to run in its own separate app. For each DB Health Check, make sure the option is selected to save the results to a file. This option can be found in the Settings tab of the DB Health Check Properties window (right click on DB Health Check action and select Properties). Then, for each of those apps, after the DB Health Checks action, add an e-mail action that will e-mail the group you want to receive the DB Health Check results for that database. Make sure to attach the results file from the DB Health Check to this e-mail. When scheduling this to run, schedule the whole app to run, instead of just the DB Health Checks action. By scheduling the whole app, the DB Health Checks will run first and then the e-mail will be sent out with the results file.