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

Program last run date

Former Member — Tue, 21 Nov 2006 11:49:02 GMT

Hi ,

I need the last run date of any program. The program would have been run for the last time some 3 years ago like that. Where do we get this data.

ST03N and STAT does not seem to be useful as they donot give run date if the run date is very long back as in this instance.

Thanks & Regards,

Vishnu Priya

Re: Program last run date

Former Member — Tue, 21 Nov 2006 12:00:14 GMT

Hi Priya,

chk this table FRUN

Re: Program last run date

Former Member — Tue, 21 Nov 2006 12:05:25 GMT

This table FRUN does not have entries in my system.

Re: Program last run date

Former Member — Tue, 21 Nov 2006 12:06:59 GMT

Hi,

chack stat transaction

check following threads

hope this helps

Re: Program last run date

anversha_s — Tue, 21 Nov 2006 12:07:52 GMT

Hi,

try this.

v can query the Table TVAVRV as follows:
 
select single low
from tvarv into last_date
where name = 'LAST_RUN_DATE_END'
and type = 'P' "variable
and numb = 0. "variable
 
* Assign last run date to variable 
last_date_end = last_date."variable
 
* update the run date in TVARV table
clear tvarv.
move 'LAST_RUN_DATE_END' to tvarv-name.
move 'P' to tvarv-type.
move 0 to tvarv-numb.
move sy-datum to tvarv-low.
modify tvarv.

Rgds

Anver

Re: Program last run date

Former Member — Tue, 21 Nov 2006 12:10:14 GMT

good

i dont think you can get the data of the program that has been run 3yrs back,if it is a smartform or sapscript program than you can check with sp01 and if it is a report than you can check inAL01 but i dont think they ll return you 3yrs data.

thanks

mrutyun^

Re: Program last run date

Former Member — Tue, 21 Nov 2006 12:16:03 GMT

Try,

BP_FIND_JOBS_WITH_PROGRAM Fm

Re: Program last run date

Former Member — Tue, 21 Nov 2006 12:19:29 GMT

Hi,

If you know the job name of that programme if it used to execute in the background then through sm37 u may check the latest run .

For on-line no idea .

Cheers.