Create a new service (a task or set of tasks). Service Broker will use the name of the service to route & deliver messages.
Syntax CREATE SERVICE service [AUTHORIZATION owner] ON QUEUE [schema.]queue [(contract | [DEFAULT] [,...n])] [;] Key service The service to create. owner A database user or role queue The queue that receives messages for this service contract A contract for which this service may be a target DEFAULT A valid target for DEFAULT contract conversations
Each service may be a target for one (or more) contracts, each of these will expose functionality to other services.
Example
CREATE SERVICE [//ss64.com/Demo]
ON QUEUE [dbo].[DemoQueue]
([//ss64.com/Demo/DemoSubmission]) ;
"Every man has a right to risk his own life for the preservation of it" ~ Jean Jacques Rousseau, The Social Contract
Related commands: