"Wait for DBQueue processor" after adding CPUs (212550)

More CPUs have been added to the database server, and the check for count of CPUs against existing SQL Server Agent Jobs is failing.

Identity Manager Front-ends display the message "Wait for DBQueue processor" and the "QBM_PDBQueueProcess_Main" SQL agent job is failing.

To solve this issue re-create the  SQL Server Agent Jobs for the Watchdog, Main Agent and the individual slots.

1. In JobQueueInfo -> Menu -> Help -> Emergency Stop -> Stop DBQueue processing
2. Check for running sessions:
   

   SELECT spid, program_name, login_time, hostname
   FROM sys.sysprocesses
   WHERE program_name LIKE 'SQLAgent%'
   AND dbid = DB_ID()

3. Wait for them to finish and then execute these commands:
   

   -- Shutdown DBQueue and processors

   EXEC QBM_PWatchDogPrepare 1

   GO

   EXEC QBM_PDBQueuePrepare 1

   GO

   -- Cleanup DBQueueCurrent

   EXEC QBM_PDBQueueCurrentRestore 0, @IgnoreGeneration = 1

   GO

   -- Restore the agents

   EXEC QBM_PDBQueuePrepare 0, 1

   GO

   EXEC QBM_PWatchDogPrepare

   GO