USP_WEALTHPOINT_UPDATEOLDDATAREFRESHJOBS

Cancels data refresh jobs whose results are ready but out of date.

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@STATUSDETAILS	nvarchar(500)	IN
@SEARCHHISTORYID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_WEALTHPOINT_UPDATEOLDDATAREFRESHJOBS(
                @CHANGEAGENTID uniqueidentifier = null,
                @STATUSDETAILS nvarchar(500) = '',
                @SEARCHHISTORYID uniqueidentifier = null
            )
            as
            begin

                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                declare @DATESUBMITTED datetime
                select @DATESUBMITTED = DATESUBMITTED from dbo.WPSEARCHHISTORY where ID = @SEARCHHISTORYID

                update dbo.WPSEARCHHISTORY
                set
                    STATUSCODE = 5,
                    STATUSDETAILS = @STATUSDETAILS,
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = @CURRENTDATE
                where
                    STATUSCODE in(0, 1, 2) and (DATESUBMITTED < @DATESUBMITTED)

            end