Hello people,
we noticed that the DB Queue Operation "8160 Reduce size of process tracking logs" is stuck in the queue because the runtime limit of 30 minutes is being exceeded to complete the job.
It's a new year and a lot of changes were made to AD Groups, which is presumably why this job needs longer to complete.
Our current work around has been to delete the job from DialogDBQueueCurrent, but as you would know, the job will continue to come back unless it is complete.
Does anybody know how to increase the runtime of the DB Queue in version 6? I thought it was in the SQL Agent somewhere...
Regards,
Ryu