Several articles have stated jobs will be added wherever oil is being drilled. States like Texas should be one of the few states which will actually see a rise in job demand.
http://www.nj.com/business/index.ssf/2011/10/business_at_the_port_results_i.html