if the ram is going to fail, it will usually do so within the first 2-3 hours of testing, which usually takes 4-6 cycles. you may also want to check for dust in the ram slots themselves. blow them out real well and check that the contacts are good on your ram sticks. if clearing the cmos made your computer work again, then that would typically mean that the motherboard got a bad timing reading when it probed the ram, so when you reset the bios, it reset the timing.
conclusion, continue with what you are doing, check the connections, and check the ram one at a time in the exact same slot. if more than one stick fails, chances are higher that it is the motherboard. two sticks gone bad at the same time, though definitely possible, is less probable.