UFN_EMAILJOB_ISCANCELLED

create function dbo.UFN_EMAILJOB_ISCANCELLED(@EMAILJOBID int)
returns bit
with execute as caller
as begin
    declare @CANCELLED bit
    if exists(
            select 1 from [dbo].[EMAILJOB] EJ
            inner join [dbo].[EMAIL] E on E.[ID] = EJ.[EMAILID]
            where E.[DELETED] = 0 and EJ.[ID] = @EMAILJOBID
            )
        set @CANCELLED = 0
    else
        set @CANCELLED = 1

    return @CANCELLED
end