Here's a report about the ongoing jobs from the US State Department as reported by Bloomberg:
http://www.bloomberg.com/news/2012-...f-jobs-fall-to-20-when-pipeline-opens-1-.html
"he number of people needed to operate and maintain the 1,661-mile (2,673-kilometer) pipeline may be as few as 20, according to the U.S. State Department, or as many as a few hundred, according to TransCanada.
“I don’t see a big jobs impact,” Stephen Fuller, director of the Center for Regional Analysis at George Mason University in Arlington, Virginia, said in an interview. “It gets the oil into refineries that already exist. It’s like replacing a bridge on the highway.”
Even the pipeline owners put the number as under 1000:
"TransCanada Vice President Robert Jones said permanent jobs would be “in the hundreds, certainly not in the thousands,” in a Nov. 11 interview on CNN."
Here's a story about an oil sands spill in Michigan:
http://www.npr.org/2012/08/16/158025375/when-this-oil-spills-its-a-whole-new-monster
"TransCanada told Daniel in writing that questions about spills were hypothetical because their pipeline would be designed not to spill. But in a document for the State Department, TransCanada predicted two spills every 10 years over the entire length of its Keystone XL pipeline, from Canada to the Gulf of Mexico. Some scientists argue that the company underestimates that risk. Another pipeline it put into service two years ago has had 14 spills in the United States, although most were small, according to TransCanada."
Is it a "small spill" if virtually uncleanable, thick gunk invades your town or your property?
Here's another one:
https://www.commondreams.org/headline/2014/03/26-4
Here's one that kept spilling for over nine months with no stoppage or way to clean up:
http://thinkprogress.org/climate/2014/02/09/3268751/alberta-tar-sands-leaking/
To summarize:
Virtually no continuing US jobs
Virtually none of the oil will be sold or used in US
Clean up of inevitable spills is nearly impossible
Strengthens our trading partners but not the US
It really makes no sense.