more sql development for local job tracking