Once I have met with my advisor, when will the advising hold be released?

Your advisor will release your advising hold at the time of your appointment.