USP_EXCHANGECALENDARSYNC_UPDATELASTRUNON

Updates the LASTRUNON value for a given exchange calendar synchronization.

Parameters

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

Definition

Copy



            create procedure dbo.USP_EXCHANGECALENDARSYNC_UPDATELASTRUNON
            (
                @ID uniqueidentifier, 
                @LASTRUNON datetime,
                @CHANGEAGENTID uniqueidentifier
            )
            as            
                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                update 
                    dbo.EXCHANGECALENDARSYNC    
                set
                    LASTRUNON = @LASTRUNON,
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = getdate()
                where
                    ID = @ID;