Police have launched an investigation following a shooting near a school in Birmingham which left a man with gunshot wounds in his leg.