Is it possible for me to get a script which will email me if there is any message/error message in the alert log and any script which will help me monitor the live database. We're using win2000 and 98 machines.
I'd really appreciate all the help I can get.
normally, when on Unix, I just use a .cmd/.bat file on the NT frontend which FTPs the monitoring files to my desktop. Our Unix box doesn't allow any email out so this is another solution. With FTP, you could send your alert-logs, monitoring files, and anything else to specific folders on your desktop if you wanted (which can be helpful).
One of the things it has is a db health report (very configurable) that can be run from a command prompt or
within the EZSQL GUI. It can send you email when a variety
of conditions exist in the database. It doesn't check the
alert log though.