Any one can have any thoughts on this issue please?
I have a schedule to run everyday at 12:00 AM. So It runs everyday.
The problem is, if the schedule updates the records one day it does not do that the other day.
My code was running properly until the scheduling user was changed.
What does the code do ?
The code queries on an object and gets records created today and creates the same records in another object.
Example: The Cases are queried and cases created today are fetched and stored in another object.
The same code was working perfectly fine since recent past. The user who scheduled this initially is inactive now. So it schedule was put in back using other user (System Admin).
Since then the schedule runs daily. But, one day it does what it supposed to and on the other day it just runs till the query and does not create the records in the target object.