Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tree: 4a4c47dbed
Fetching contributors…

Cannot retrieve contributors at this time

21 lines (16 sloc) 0.785 kb
-- To check if the engine running status
use [SCRules];
select t.RunningFlag from SCRules..ControlApplication t where t.ApplicationID = '1';
select * from vAuditRTProcessMessage t where t.ProcessID not in (520) order by t.MessageKey desc;
update scrules..ControlApplication set runningflag='0' where applicationid='1';
USE [SCRules];
GO
DECLARE @returnValue INT;
GO
--EXEC @returnValue = [dbo].[CTL_LaunchSubscriber];
SET @returnValue = '100';
GO
SELECT 'returnValue' = @returnValue
GO
select max(DateKey) from scrules..auditCTBatch where ApplicationId='1' and StatusID='6' group by batchid;
select ChangeDate from scrules..GlobalDateSmall where DateKey = (select max(DateKey) as "DateKey" from scrules..auditCTBatch where ApplicationId='1' and StatusID='6' group by batchid);
Jump to Line
Something went wrong with that request. Please try again.