USP_AUTOSETTLEBBMSTRANSACTIONS_ENABLEDISABLE
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@CHANGEAGENTID | uniqueidentifier | IN | |
@ENABLE | bit | IN |
Definition
Copy
CREATE procedure dbo.USP_AUTOSETTLEBBMSTRANSACTIONS_ENABLEDISABLE
(
@CHANGEAGENTID uniqueidentifier,
@ENABLE bit
)
as begin
declare @AUTOSETTLEPROCESSID uniqueidentifier = '0A350644-832E-45BE-99FC-90BCCA0AD216'
if exists (select [ID] from dbo.[SCHEDULE] where [ID] = @AUTOSETTLEPROCESSID)
begin
update dbo.[SCHEDULE]
set
[ENABLED] = @ENABLE
where [ID] = @AUTOSETTLEPROCESSID
end
return 0;
end