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