03-11-2013 3:34 PM
Hello All,
We have background jobs those run with user ID MAESTRO. I want to analyse the SQL trace for these jobs, however from ST05 I see we can enable the jobs for different user using the option activate Trace with Filter. I have activated using this option for user MAESTRO but after the finish of jobs, I have deactivated the trace and tried to list the trace for user MAESTRO.When ever I do this it always says Trace doesn't exist.Could you kindly let me know how can I enable the sql trace for the jobs running on different user.
Regards,
Sai
03-11-2013 9:00 PM
Hi,
are you sure you activated the SQL trace on the same application server where the job was running?
(ST05 is application server dependent)
Another hint: the user that scheduled a job is not necessarily the user that executes a step in the job.
Make sure to trace the right user on the right server.
Kind regards,
Hermann
03-11-2013 3:49 PM
03-11-2013 9:00 PM
Hi,
are you sure you activated the SQL trace on the same application server where the job was running?
(ST05 is application server dependent)
Another hint: the user that scheduled a job is not necessarily the user that executes a step in the job.
Make sure to trace the right user on the right server.
Kind regards,
Hermann
03-12-2013 7:42 AM
Hi Sandeep,
You have already good suggestions from Hermann what is probably the root cause.
Message that you are getting means that no action was registered for tracing. To check on which server and what user is running the job, start the batch job, go to SM51 and choose server to see list of jobs in progress with user name. In general you can switch between application server with SM51.
The easiest thing to do is to assign batch job run to specific server and run ST05 from same server. Then you are sure that logs will be collected, assuming you know the right user.
Regards,
Adam
03-12-2013 1:17 PM