DECLARE @cnt int = 0;
SELECT @cnt = count(*) FROM sys.conversation_endpoints WITH(NOLOCK)
WHERE far_service = 'OrderEngineSellProcessService'
if ( @cnt = 0 )
begin
DECLARE @i int = 1
, @intDialogCount int = 0
, @bit150TrickEnableFlag bit
, @uidDialogHandle uniqueidentifier;
SELECT @intDialogCount = DialogCount * (CASE _150TrickEnableFlag WHEN 0 THEN 1 ELSE 150 END)
, @bit150TrickEnableFlag = _150TrickEnableFlag
FROM dbo.DIALOGORDERENGINESELLPoolConfig;
TRUNCATE TABLE dbo.DIALOGORDERENGINESELLPOOL;
WHILE @i <= @intDialogCount
BEGIN
BEGIN DIALOG CONVERSATION @uidDialogHandle
FROM SERVICE xxxxxxx
TO SERVICE 'xxxxxxxx'
ON CONTRACT xxxxxxxxxxx
WITH ENCRYPTION = OFF;
IF @bit150TrickEnableFlag = 0 OR (@bit150TrickEnableFlag = 1 AND (@i % 150) = 0)
INSERT dbo.DIALOGORDERENGINESELLPool (DialogHandle)
VALUES (@uidDialogHandle);
SET @i += 1;
END
END
여기서 cnt=0일때만 실행되는거 맞죠?
네.