update_email_resetdate job does not consider opt out on hold
The update_email_resetdate job is used to validate emails that may have soft bounced but later successfully received emails. However, the query does not exclude emails that were placed on hold as an Opt Out -- it treats all on-hold emails as the same. This means someone might receive a mailing, opt out, and then be taken off hold.
Send a mailing to a contact. Put their email on hold with the opt-out option. Run the scheduled job.
You will see the email is taken off hold.
Email is left on hold.