topic Re: Starting SQL-Trace Automatically - Transaction Code: ST05 in Application Development and Automation Discussions

Starting SQL-Trace Automatically - Transaction Code: ST05

Former Member — Thu, 15 Dec 2011 07:30:40 GMT

Good Morning Experts!

I have got a problem with my "SAP - Business Warehouse (BW) System".

We have very much Traffic on this System every night (between 03:00 and 04:00 a.m.).

Because nobody is at work so early in the morning, I wanted to ask you, if there is a possibility to start the SQL-Trace (which you can call by transaction code: ST05) automatically.....?

Is there a possibility to write a short ABAP Code to start the SQL-Trace automatically?

Thank's and best regards.

Re: Starting SQL-Trace Automatically - Transaction Code: ST05

Former Member — Thu, 15 Dec 2011 09:24:59 GMT

hi,

i think u can do it by back ground job scheduling...by this we can automatically do job scheduled for the desired time...

thanks

chaitanya

Re: Starting SQL-Trace Automatically - Transaction Code: ST05

Former Member — Thu, 15 Dec 2011 10:32:41 GMT

Hello Chaitanya.

Thank you for answering so fast.

Can you explain me a little more detailled how to set up such a job in the backend system ?

Best regards.

Re: Starting SQL-Trace Automatically - Transaction Code: ST05

Former Member — Thu, 15 Dec 2011 12:51:54 GMT

hi,

u can schedule a back ground job in tcode SM36.there job wizard & giv job name there u can do i think so this answer will be useful i hope...

thanks

chaitanya

Re: Starting SQL-Trace Automatically - Transaction Code: ST05

Former Member — Thu, 15 Dec 2011 14:40:26 GMT

ST05 is not an executable report. You might try writing a program that calls it in a call transaction session and then submitting that program in a batch job.

Rob

Re: Starting SQL-Trace Automatically - Transaction Code: ST05

Former Member — Fri, 16 Dec 2011 08:46:16 GMT

Hello Rob.

Thank you for replying.

I tried to create a job with the "Job Wizard" with SM36.

Now i realized, that i have to wirte my own ABAP-Report (Programme), which uses the ST05 SQL-Trace function.

I am not an ABAP-Professional, so would you be so kind and give me the code-lines of this programme?

I can not imagine if you have to write only 5-10 lines or if the code is much longer...

Thank you and best regards.

Re: Starting SQL-Trace Automatically - Transaction Code: ST05

Former Member — Fri, 16 Dec 2011 11:15:39 GMT

Hit F1 on statement CALL TRANSACTION. There you'll have all explanation you need do create your program!

Best Regards

Mauricio