• Maybe can use this after your query:

    If @@rowcount = 0

    Begin

    SET @tableHTMLA = 'No failed jobs reported'

    End