Anyone remember a movie about a man who was haphazardly picked to be an astronaut?

Question

The only part I remember was the character kept singing an obnoxious song over and over( may have been 100 cans of beer on the wall) and over to the complete annoyance of the other (real)astronaut. My daughter and I watched it around 1996-99.

Answer 1

Rocket Man with Harland Williams.

Answer 2

Rocketman...
The song was... He's got the Whole World in His Hands.

THe movie was a takeoff of The Reluctant Astronaut with Don Knotts.

Answer 3

Gotta be Rocket Man!