The looming job losses at the University of Dundee should be a “wake-up call” for the Scottish Government to take action to support the sector, John Swinney has been told.