UFN_PROCESSCMSEMAIL_LOOKAHEAD

CREATE function dbo.UFN_PROCESSCMSEMAIL_LOOKAHEAD
(
    @BUSINESSPROCESSPARAMETERSETID uniqueidentifier = null
)
returns bit
as begin

    declare @NEXTID as int = 0;

    select top 1 @NEXTID = EJ.ID
    from dbo.EMAILJOB EJ
    inner join dbo.EMAIL E on E.ID = EJ.EMAILID
    where EJ.[STATUS] in (2,13)
    --2 Prepared Jobs

    --13 Processed Jobs that failed during upload    

    and E.[DELETED] = 0
    and EJ.[CURRENT] = 1
    and EJ.[SENDAFTERDATE] <= GETUTCDATE();

    if @NEXTID > 0
        return 1;

    declare @RUN as bit = 0;
    select top 1 @RUN = 1 from dbo.EMAILSCHEDULE WHERE SCHEDULEENABLED = 1;
    return @RUN;
end