Skip to Content
Former Member
Jan 29, 2007 at 11:52 AM

Need to fetch updated records by Back ground scheduling



I have a report program which fetches the employee details. I have created a back ground job for this report program. When the job executes for the first time it should fetch all the records. But when the job executes for the second time and so on it should retrieve only the updated records.

I will explain in detail.

Suppose I execute the job today for the first time , it should retrieve all the employee records . But tomorrow if the job executes, it should retrieve those records that are inserted or changed in these 24 hrs of time.

Could any body tell me the necessary programming logic.

Reward points are assured.

Best regards