UFN_BUSINESSPROCESSSTATUS_CURRENTENQUEUEDJOBID

create function dbo.UFN_BUSINESSPROCESSSTATUS_CURRENTENQUEUEDJOBID
(
  @BUSINESSPROCESSCATALOGID uniqueidentifier
)
returns bigint
with execute as caller
as begin

  declare @ENQUEUEDJOBID bigint = 0;

  select
    @ENQUEUEDJOBID = isnull(max([ENQUEUEDJOBID]), 0)
  from 
    dbo.[BUSINESSPROCESSSTATUS] with (nolock) 
  where 
    [BUSINESSPROCESSCATALOGID] = @BUSINESSPROCESSCATALOGID and 
    [STATUSCODE] in (1, 4);

  return @ENQUEUEDJOBID;
end