Councillors called for a 'deep dive' into job creation, although a disagreement saw one TVCA committee member walk out