USP_BATCHWORKFLOWTASK_DELETE

Executes the "Batch Workflow Step: Delete" record operation.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_BATCHWORKFLOWTASK_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)                    
as 
set nocount on;
declare @contextCache varbinary(128);

begin try                    
    /* cache current context information */
    set @contextCache = CONTEXT_INFO();

    /* set CONTEXT_INFO to @CHANGEAGENTID */
    if not @CHANGEAGENTID is null
        set CONTEXT_INFO @CHANGEAGENTID

    delete from dbo.BATCHWORKFLOWTASK where ID = @ID                        

    /* reset CONTEXT_INFO to previous value */
    if not @contextCache is null
        set CONTEXT_INFO @contextCache

end try
begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
end catch

return 0;