Certainly in the early days of NAFTA when it was just the US and Canada, there were some adjustments. Canadians noticed some jobs were lost to the US due to consolidations, usually in the heavy manufacturing industries. We also lost jobs in areas like steel making, where some of our smaller less efficient operations couldn't compete with the larger US firms. Of course, if we hadn't done NAFTA, they might have gone anyway, as the competition came from the east.
I also know that Canada gained a few jobs in some sectors from the US, particularly in high tech, but also in some areas like the movie industry, call centres and other areas.
I don't know that there are any known answers here. You can compare the job rates in different countries and look at their trade. Everyone in California complains about movie making in Canada, and how it is taking away their livlihood, but if you looked at the profits that US studios make when their movies are shown in Canada, I'm pretty certain you would find that its higher than the business we take away when a studio movies are shot in Canada.
Tom Daschle(Dem Senator) is currently forcefully blocking the importation of Canadian Beef into the US because of 1 Canadian cow with BSE. This despite the fact that the US(and Canada) import Kobe beef from Japan, which has had 3 cases. He thinks he is helping the US cattle industry. In reality, the Canadian and US markets are(were) very integrated and dependant on each other. US farmers are hurting for breeding stock, and Canadians don't have enough meat packing capacity to deal with all the cattle they aren't shipping south.
Its never a simple answer.
James