Larry, If I were going to bother setting up any check I think I would output the results to a file and then do something with the file if there were to be an error. Actually, the help doesn't make it clear if the error var is set when you run with the FULL option. If so you might need to check first without and then run with FULL if you want to see what the error is.
A potential loophole, as I'm sure you know already, is that the indexes don't get checked... Regards, Alastair. From: Lawrence Lustig Sent: Wednesday, January 27, 2010 2:44 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Automating AUTOCHK. 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 ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2648 - Release Date: 01/27/10 07:36:00
