Service Broker Service Broker SELECT isbrokerenabled FROM sys
데이터 베이스에서 Service Broker 설정 § Service Broker 상태 확인 SELECT is_broker_enabled FROM sys. databases WHERE database_id = db_id() § Service Broker 사용가능으로 설정 ALTER DATABASE Adventure. Works SET ENABLE_BROKER
Contract 생성 § message type 생성 CREATE MESSAGE TYPE [//Adventure-Works. com/Expenses/Expense. Claim] VALIDATION = WELL_FORMED_XML CREATE MESSAGE TYPE [//Adventure-Works. com/Expenses/Claim. Response] VALIDATION = VALID_XML WITH SCHEMA COLLECTION awschemas § Contract 생성 CREATE CONTRACT [//Adventure-Works. com/Expenses/Process. Expense] ( [//Adventure-Works. com/Expenses/Expense. Claim] SENT BY INITIATOR, [// Adventure-Works. com/Expenses/Claim. Response] SENT BY TARGET )
Queue 생성 § 활성화 매개변수 지정 CREATE QUEUE Expense. Queue. With. Activation WITH STATUS = OFF, ACTIVATION ( PROCEDURE_NAME = Process. Expense, MAX_QUEUE_READERS = 5, EXECUTE AS SELF)
Service 생성 CREATE SERVICE [//Adventure. Works. com/Submit. Expense] ON QUEUE Expense. Queue ( [//Adventure-Works. com/Expenses/Process. Expense] )
메시지 송신 § § dialog handle 변수 정의 dialog conversation 시작 DECLARE @dialog_handle uniqueidentifier BEGIN DIALOG CONVERSATION @dialog_handle FROM SERVICE [//Adventure-Works. com/Submit. Expense] TO SERVICE '//Adventure-Works. com/Process. Expense' ON CONTRACT [//Adventure-Works. com/Expenses/Process. Expense] 메시지 송신 ; SEND ON CONVERSATION @dialog_handle MESSAGE TYPE [//Adventure-Works. com/Expenses/Expense. Claim] (@msg. String)
메시지 수신 § § 메시지 저장할 변수 정의 RECEIVE 구문 호출 message type 확인, 순서대로 처리 Conversation 끝나면, END CONVERSATION 호출 DECLARE @conversation UNIQUEIDENTIFIER DECLARE @msg NVARCHAR(MAX), @msg. Type NVARCHAR(256) ; RECEIVE TOP(1) @conversation = conversation_handle, @msg. Type = message_type_name, @msg = message_body FROM Expense. Queue IF (@msg. Type = '//Adventure-Works. com/Expenses/Expense. Claim') -- process @msg … END CONVERSATION @conversation
구성파일 Parameters File documentation Instance settings Application settings Protocol settings Delivery channels Argument encryption
ADF(Application Definition File)파일 Parameters File documentation Database settings Event classes Subscription classes Notification classes Provider settings Generator settings Distributor settings Application execution settings
이벤트 제공자 § 표준 제공자 – File. System. Watcher – SQL Server § 커스텀 제공자 API – – Managed event API COM event API XML event API SQL Server event API
- Slides: 24