Vasectomy...should he?

I know most men hate the thought, but how bad is the experience? My husband and I are considering it. In the end it is his call but I would like to know what he will go through.