Skip to Content
0
Former Member
Nov 10, 2005 at 04:36 PM

weird database behaivor

20 Views

Hi, I have 3 jobs running, job A runs first and inserts data into a table, several minutes later, jobs B and C run, the job B finds the data and process it, when job C runs, it sometimes doesn't find any data, we have put job C to retry for 10 minutes, sometimes it runs before job B, and because of the retry, also runs after job B, and still doesn't find the data.

We have two servers, one for de DB and the other for APP, the workload is balanced between them, the problem is not constant, as far as we have noticed, it occurs during heavy workloads on the system.

Any ideas or suggestions are welcome.

Thanks