James Douglas, 2nd Duke of Queensberry and Dover (1662–1711), Secretary of State for Scotland (1709–1711)