USP_RECORDOPERATION_DISABLERECORDOPERATIONWORKFLOWTRIGGER

Executes the "Record Operation Workflow Trigger: Disable" record operation.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy


CREATE procedure dbo.USP_RECORDOPERATION_DISABLERECORDOPERATIONWORKFLOWTRIGGER
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin
    set nocount on;

    update dbo.RECORDOPERATIONWORKFLOWTRIGGER set ENABLED = 0 where ID = @ID;

    return 0;
end