Would you enjoy working being on-call and working on a production issue at 2:30 in the morning?

As a programmer who had never worked in an on-call role, I had to fudge my way around this, as I really didn't know how I would feel having to work a production issue at 2:30 in the morning. I said I would do whatever the job required.