We have 72 Sybase hosts viz,

and every host has 2 sybase databases having the same sa password for all the sa login across all the hosts.

Can anyone help me write a script which checks for daily dumps in all the 72 hosts and writes team an email everyday so that if there's a failure we can take appropriate actions.

Any other approach other than that of scanning error log for the current date or "DUMP is complete" should be feasible as there the error logs have grown quite big and aren't purged.

I remember that the column 'dumptrdate' in sysdatabases table captures information about the latest dump. Can we go with that approach?

Please help.