The government says the agreement will support thousands of jobs, including more than 2,000 in Scotland.