• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 96 subscribers
  • Views 4255 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Stucking DBQueue

jordanics ferenc

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

  • 0

    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

  • 0

    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.