Hello
How can I delete or purge the stucking DBQueue
Nothing processing just I see several process in DB Queue.
Thank you and kind regards
Ferenc Jordanics
Hello
How can I delete or purge the stucking DBQueue
Nothing processing just I see several process in DB Queue.
Thank you and kind regards
Ferenc Jordanics
Hello,
It's not a good idea to delete anything from the DBQueue. What is the status of the tasks? Are they in a IsReset = Yes state?
Are there any frozen jobs in the job queue?
Trevor
Without knowing what the error is, have you checked the DBJournal? Then it's hard to know. A global "catchall" scenario may be to recreate the sql agent jobs (there are Support KBs that show how) and see if that fixes it.