Ask the Community
Groups
How do I enable the disabled SQL broker queues - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>PROBLEM:</strong></p> <p>On the perftest.asp page, I see that some of my SQL Broker queues are disabled. How do I enable the disabled SQL broker queues?</p> <p> </p> <p><strong>SOLUTION:</strong></p> <p>Run the following query in SQL to re-enable the SQL broker queues on your system.</p> <div>USE ksubscribers<br>DECLARE <a href="https://kaseya.vanillacommunities.com/profile/queueName" rel="nofollow">@queueName</a> VARCHAR(255)<br>DECLARE <a href="https://kaseya.vanillacommunities.com/profile/dcommand" rel="nofollow">@dcommand</a> VARCHAR(255)<br>DECLARE vend_cursor CURSOR<br>FOR <div> <br>select name from sys.service_queues where is_receive_enabled = 0 and is_enqueue_enabled = 0</div> OPEN vend_cursor<br>FETCH NEXT FROM vend_cursor<br>INTO <a href="https://kaseya.vanillacommunities.com/profile/queueName" rel="nofollow">@queueName</a><br><a href="https://kaseya.vanillacommunities.com/profile/FETCH_STATUS" rel="nofollow">@FETCH_STATUS</a> = 0<br>BEGIN<br>SET <a href="https://kaseya.vanillacommunities.com/profile/dcommand" rel="nofollow">@dcommand</a> = 'ALTER QUEUE ' + <a href="https://kaseya.vanillacommunities.com/profile/queueName" rel="nofollow">@queueName</a> + ' with status = on' <br>EXEC(<a href="https://kaseya.vanillacommunities.com/profile/dcommand%29" rel="nofollow">@dcommand)</a><br>FETCH NEXT FROM vend_cursor<br>INTO <a href="https://kaseya.vanillacommunities.com/profile/queueName" rel="nofollow">@queueName</a><br><br>END<br>CLOSE vend_cursor<br>DEALLOCATE vend_cursor<br>SET <a href="https://kaseya.vanillacommunities.com/profile/dcommand" rel="nofollow">@dcommand</a> = 'ALTER DATABASE [ksubscribers] SET NEW_BROKER WITH ROLLBACK IMMEDIATE;'<br>EXEC(<a href="https://kaseya.vanillacommunities.com/profile/dcommand%29%C2%A0" rel="nofollow">@dcommand) </a></div> <p> </p> </article> </main>