Can you provide the where statement and strip any confidential information. Is it possible that you are using implicit context loads and that is being pulled from a file or database that then has changed breaking your where statement. Check the where statement again and just repubublish it again would be my 2 cents if the job is still working in the studio though.
So basically everything was right and we republished it in snapshot ( previously it was published as released ) and it worked for one more week, and then again stopped working.
In that time republished was the only option then after some new update done by Admin team on TAC we never see the issue again.
