topic Re: maintaining program last run date in Application Development and Automation Discussions

maintaining program last run date

Former Member — Fri, 31 Oct 2008 09:51:05 GMT

Hi Experts,

The program will be run on a daily basis. To avoid duplication of data the extract should store the last run date. Every time it runs it should check the last run date and return only records subsequent to that run date. Can anyone please give the solution.

Regards,

venkatesh

Re: maintaining program last run date

h_senden2 — Fri, 31 Oct 2008 09:54:17 GMT

what you can do is add a record to the TVARV table with the last run date of the program.

At the beginning of the program you check this record.

At the end you have to update this record with the current date.

regards,

hans

Re: maintaining program last run date

Former Member — Fri, 31 Oct 2008 09:55:21 GMT

Since the job runs daily only once. When you extract the data use sy-datum to extact the data.

If it runs more than once, then create a table to store the program name , last run date and last run time.

regards,

Advait

Re: maintaining program last run date

kesavadas_thekkillath — Fri, 31 Oct 2008 09:55:35 GMT

Create a Z table and do that.

Re: maintaining program last run date

Former Member — Fri, 31 Oct 2008 09:59:52 GMT

Dear Venkatesh,

You need to create custom table for the same.Wherein you will be storing the date and time,at the end of your program.At the start of your program ,you can select the record with max date and time from this table.This way scenario can be easily handled.

Hope it helps you.

Re: maintaining program last run date

Former Member — Fri, 31 Oct 2008 10:05:28 GMT

Dear Venkates,

u can do this by maintaining the last run date in some ztable

ztimestamp

when u execute the program check whether ur current date is greater thna the value stored in the ztimestamp.

but remember u nedd to use locking mechanism for this

after the execution update the Ztimestamp with the current value

use the enqueu and deque functionality

u need to do this to avoid simultameous update to ur timestamp.

hope it solves ur problem.

thanks sushant

Re: maintaining program last run date

Former Member — Fri, 31 Oct 2008 10:16:38 GMT

Hi,

Thanks for your valuable solution.

regards,

venkatesh