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: