Change a service (a task or set of tasks)
Syntax ALTER SERVICE service [ON QUEUE [schema.]queue] [(ADD | DROP CONTRACT contract [,...n])] [;] Key service The service to create. queue The queue that receives messages for this service contract A contract for which this service may be a target
Each service may be a target for one (or more) contracts, each of these will expose functionality to other services.
Example
ALTER SERVICE [//ss64.com/Demo]
ON QUEUE [dbo].[NewQueue] ;
"Every man has a right to risk his own life for the preservation of it" ~ Jean Jacques Rousseau, The Social Contract
Related commands: