I have an application that a process for every record in a table (called TobeProessed, user enter records). When it finishes the reord it will delete it from the table. When there is no record in the table, the app will just seating there, and check the table every 5 seconds to see if there are new records.
However, After running 3 days or so, the system will freeze. Sometiems the screen go blank, other times just the app frozen, even if there is no records to process. For example, If I start the App mid-week, it will finishes all user inputed record by saturday, but the system frozen on Sunday.
Any ideas where to look? Thanks in advance