USP_FEEDALERTINSTANCEWORKFLOWTRIGGER_UPDATEDATELASTPROCESSED

Updates the date last processed value for the given feed alert instance workflow trigger.

Parameters

Parameter	Parameter Type	Mode
@FEEDALERTINSTANCEWORKFLOWTRIGGERID	uniqueidentifier	IN
@DATELASTPROCESSED	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_FEEDALERTINSTANCEWORKFLOWTRIGGER_UPDATEDATELASTPROCESSED
(
    @FEEDALERTINSTANCEWORKFLOWTRIGGERID uniqueidentifier,
    @DATELASTPROCESSED datetime,
    @CHANGEAGENTID uniqueidentifier
)
as
set nocount on;

begin try
    update dbo.FEEDALERTINSTANCEWORKFLOWTRIGGER
        set DATELASTPROCESSED = @DATELASTPROCESSED,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()
    where ID = @FEEDALERTINSTANCEWORKFLOWTRIGGERID;

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

return 0;