Stuart McLachlan
stuart at lexacorp.com.pg
Sun Nov 2 03:25:41 CST 2003
On 31 Oct 2003 at 15:13, Tony Septav wrote: > Hey All > I have a program designed for a client that runs basically 24 hours a > day, 7 days a week collecting and processing data. Is it possible to > schedule a once weekly repair and compact operation on both the frontend > and backend (or even for now just the backend). There is a lag/idle time > between 1AM and 4AM, when no data is collected or processed. Any > direction to available code, ideas or programs would be appreciated. > Thank you. > How about a timer which periodically checks the date/time. If it's Sunday 2.00am or whenever, shell to a batch file and close the app. In the batch file open another one that waits for a while then compacts and repairs the first one and re-opens it. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.