incorrect query resulting in non functional job purging