I recently discovered that a client's database had been carrying around a truncated table error for several weeks. Using indexed SELECTs, I was able to retrieve the data. However, I'd like to install an automated AUTOCHK procedure to run nightly, which will email a warning to the appropriate people if an error is detected.
I already have a system installed to run automatic procedures at various times, and to send the emails. Right now, I'm thinking about nothing more complex than simply CONNECTing, issuing AUTOCHK, checking the ERROR variable and, if it's not 0, sending a couple of emails. Can anyone who has already automated this procedure provide any advice beyond the simple system I'm thinking about? Can anyone suggest additional measures of database health beyond AUTOCHK? -- Larry
