Skip to Content
0
Former Member
Jul 20, 2009 at 03:36 PM

Lat job rundate and time

43 Views

Hi All,

I want to get the last job run date and time from TBTCO Table . My program will schedule for every 30 mins.

I have to get the Last job run date and time from TBTCO table. Is there any function module to get the last job run date and time from TBTCo table.

I have used the below code.

SELECT * from tbtco into table t_tbtco where jobname = 'ZWELOMDM_KEY_TABLE_LOAD' and status <> 'A'.

if sy-subrc = 0.

SOrt t_tbtco by strtdate strttime Ascending .

read table t_tbtco index '1'.

but sometimes its not woking .

Does Select with Max will work for this.

Thanks,

Madhu