I have not said one work about long term jobs.  But for once you are sort of right.  Once complete the pipe will result in a net loss of long term jobs.   The number of trucks required and train cars will be reduced.  The people who work there will lose some jobs.  Of course there will be fewer big rigs on the road hauling the crude oil and burning diesel.  That will increase traffic safety.  There will also be less shipped by rail.  Both of those methods are much more dangerous and also cause pollution.   There have already been incidents of the tankers used exploding when there is an accident.  Both of those methods haul the oil through many cities.