USP_BUSINESSPROCESSSCHEDULELASTRUN_UPDATE

create procedure dbo.USP_BUSINESSPROCESSSCHEDULELASTRUN_UPDATE (
    @LASTRUNTIME datetimeoffset(3) = null
)
as
begin
    if @LASTRUNTIME is null
        set @LASTRUNTIME = sysdatetimeoffset();

    if exists(select top 1 1 from BUSINESSPROCESSSCHEDULELASTRUN)
        update dbo.BUSINESSPROCESSSCHEDULELASTRUN
        set LASTRUNTIME = @LASTRUNTIME;
    else    
        insert into BUSINESSPROCESSSCHEDULELASTRUN (LASTRUNTIME) values (@LASTRUNTIME);
end