UFN_BUSINESSPROCESSJOBSCHEDULE_ISJOBUSERID

CREATE function dbo.UFN_BUSINESSPROCESSJOBSCHEDULE_ISJOBUSERID (@APPUSERID uniqueidentifier)
returns bit
with execute as caller
as
begin

  declare @ISJOBUSER bit

  if exists 
  (
    select CHANGEAGENT.ID 
    from dbo.CHANGEAGENT 
    inner join dbo.APPUSER on APPUSER.USERNAME = CHANGEAGENT.USERNAME
    where CHANGEAGENT.APPLICATIONNAME = 'Blackbaud App Server (BusinessProcessInvokeHandler)'
    and PROCESSDISPLAYNAME = 'Application'
    and APPUSER.ID = @APPUSERID
  )
    set @ISJOBUSER = 1
  else
    set @ISJOBUSER = 0

  return @ISJOBUSER

end