I want to do the check of "Alert.log Summary" that query alert_<SID>.log for ora-<errors>. So far I've been doing this manually by using the option "Health Check" while I have toad Open, but I would like to have this automated by using UNIX cron, but not sure if it is possible.
Is health check a built-in function within Toad or is a series of plain text queries and or routines that I just can take them and use them in order to do this, including the ability to store the results at toad.toad_health_check table?
It is a pl/sql block used to extract the alert log. Use sql monitor to discover the pl/sql that Toad runs. Then take that and transform it into your own stored procedure and run that from cron.
In Windows, you can schedule Toad to run under the task scheduler and execute the health check (there is the Schedule icon/option in the Health Check window). You can refer to Help files under "command line" for 9.6 and earlier.
Toad 9.7 should have updated documentation about new job automation and scheduling options.
