DBQueue Processor does not process tasks (4349273)

Please note that the following steps apply to version 8.2.1 and below only.

1. Execute the following steps in the database using a suitable query tool, e.g. SQL Management Studio:

Stop all DBQueue Processor components.

exec QBM_PWatchDogPrepare 1

go

exec QBM_PDBQueuePrepare 1

go


2. Check whether other database sessions are active:

select *

from sys.sysprocesses p

where dbid = DB_ID()

and spid <> @@SPID


If there are still sessions active, they must be closed first.


3. Create a new ServiceBroker ID and enable message delivery:

alter database <database name> set NEW_BROKER

go

alter database <database name> set enable_broker

go

Initializing the DBQueue Processor.

exec QBM_PDBQueuePrepare 0,1

go

exec QBM_PWatchDogPrepare

go