I have a few databases running at a customer site with various overnight agents running in each one. For one of the databases, however, the agents only seem to run for a short time - like a week - before they start backing up in the queue and quit running. So, we have to restart the server to clear the queue and then they run again. But, it’s a pain to monitor this when we shouldn’t have to.
Does anyone know of a reason why this would occur - or how I could address it?
Thanks.