On August 29, 1995, while with the Pirates, Wagner had a no-hitter broken up against the Colorado Rockies with two out in the ninth on an Andrés Galarraga single. It was the only hit Wagner would allow in defeating the Rockies 4–0. The no-hitter would have been the first by a Pirate since John Candelaria in 1976.
Wagner currently is known to be residing in Neosho, WI and to be working in the Mortgage industry. He is an ESPN sport analyst for Milwaukee-area radio sports talk channel.