I am running an automation script in Toad to do a health check on 3 databases to perform 1 task, but I'm noticing that it does not separate the databases in the e-mail results properly; instead it dumps all the results in one big line and omits all databases except the last database.
For example:
,
The app has a health check on 3 databases to perform a check of invalid objects and is set to e-mail the results as plain text. When it is tested within the properties, it works just fine, the DB's are separated into 3 sections (treeview-like) and each section informs how many invalid objects are detected for each DB.
,
But when I'm out of the properties view and I decide to run the selected app from App Designer window or decide to schedule the app, it will e-mail the results, but instead of the treeview-like results with all 3 DB's; it will only have the last DB listed on the top, but will show all invalid objects of all 3 DB's and a grand total of invalid objects equal to all 3 DB's.