Skip to content

Instantly share code, notes, and snippets.

@occdevcamp

occdevcamp/Service Broker 03 - Alter Queue for Automatic Processing

Created January 28, 2015 16:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save occdevcamp/9f76ac937d371c589584 to your computer and use it in GitHub Desktop.
Save occdevcamp/9f76ac937d371c589584 to your computer and use it in GitHub Desktop.
Download ZIP
Now, Proc_Queue_Process_Messages will be called automatically whenever a message is put on the queue – i.e. there’s no need to explicitly call it.
Raw
Service Broker 03 - Alter Queue for Automatic Processing
Use ServiceBrokerDemo
GO
Alter Queue Queue_Demo
-- Now process the queue automatically.
With Activation (
Status = On,
Max_Queue_Readers = 1,
Procedure_Name = dbo.Proc_Queue_Process_Messages,
Execute As Owner)
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment