Erik ten Hag has said he warned not to become Manchester United manager before taking over at Old Trafford, with people telling him it was an "impossible" job.