Hodges played over 170 times for the Blades in a near-five year spell at Bramall Lane, leaving a lasting impression on United fans.
A former Wales international, Hodges moved into coaching after his playing career ended and after two caretaker spells at Barnsley, he spent just over a year in charge of AFC Wimbledon before leaving last year.
Hodges was unveiled as Rovers’ new set-piece coach last week under McSheffrey, who took over last year after the sacking of Richie Wellens.
Sheffield Wednesday boss and chairman unhappy after attackers leave for Premier League
Sheffield Wednesday ‘obviously huge’ but Charlton Athletic boss makes Owls statement
What Darren Moore had to say after Sheffield Wednesday's win over Charlton Athletic
The moment that changed the game and a star man rises – How Sheffield Wednesday battled their way past Charlton Athletic
Why Sheffield Wednesday left Dennis Adeniran out completely against Charlton Athletic
“The club have put a role out there as set-piece coach and he’ll come in as that,” McSheffrey told the Doncaster Free Press, “but I know he’ll add a lot more value than that.
“He’ll share the load with things. It’s another good addition to the support network for me and we’re building a good backroom staff now.
“Glyn brings a wealth of experience, working at some good clubs.
“He was backroom staff with Mark Hughes wherever he went, including the Welsh national squad.
“He brings that experience and some great support for me.
“He came in and met the lads, took training and the energy was good. It looked a good set up and I think he’ll be good for us.”