When health check is run manually a full report is produced. But if automated and scheduled using the Automation Designer, the report produced is blank, with only the header.
Connection password not saved. The Automation Designer takes the connection information from the current session being used. If passwords for connection are not being saved, then the automated job won't be able to make a connection and run.
Health Check can run when run manaully because it is working in an open session with the database.
When connecting to the database in the Toad login window, choose to "Save Password". Create the task for Health Check in the automation designer. Then schedule as usual.
The connection and password used is saved in the connections.ini and connectionpwds.ini files in the User Files folder. They are the same info as the connection history in the Toad login/connection window.