USP_SMARTFIELD_UPDATELASTRUNON

Updates the LASTRUNON value for a given smart field instance.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@LASTRUNON	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_SMARTFIELD_UPDATELASTRUNON
    (
        @ID uniqueidentifier, 
        @LASTRUNON datetime,
        @CHANGEAGENTID uniqueidentifier
    )
    as
        update 
            dbo.SMARTFIELD    
        set
            LASTRUNON = @LASTRUNON,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()
        where
            ID = @ID;