Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

RPTARQPOST taking a lot of time in execution.

Former Member
0 Kudos

Hi All,

In production server a background report RPTARQPOST for leave requests posting is scheduled at a frequency of 8 hours.

It is taking a lot of time to execute correctly. My query is that this report will take normally this much time to execute or is it taking lot of time in our system only.

Please find below the screenshot taken from SM37 background scheduled jobs for the above said report.

Regards,

Prameet Gopal Verma

3 REPLIES 3

FredericGirod
Active Contributor
0 Kudos

Hi,

make a SQL trace on your program (ST05), when you display the trace, go in the menu and summarize the result. You will show  witch table take long time.

Give the result

Regards

Fred

0 Kudos

Sure Fred, I will do that and will check from ST05 but in the mean time would like to share the screenshot of SM37 displaying the execution time i.e. duration is seconds.

Here second last column is the duration in seconds.

Regards,

Prameet Gopal Verma

0 Kudos

I don't understand, the last column is not the delay ?   the difference of time of the schedule time and the real execution time

regards

Fred