Task did not send email as expected and need to send the email

A workaround to this situation is to copy the task, alter the SQL query in the copy to return the desired transaction only and run the copy task.