Debugging an active job

[ankit_munshi2]

Hi,

I have a job which has been running for 170,000 seconds and is still active . I need to check where it is right now (like which code line it is currently executing). I know there are many ways to debug an active job , but last time I debugged an active job , I pressed F5 in debug session and the job got cancelled.

I do not want same thing to happen to my job as it has already completed a lot of processing and might be nearing completion . Please shed some light on this.

Regards,

AM

[kamesh_g]

Hi 1. Did you check ST22 for any dumps occurred in the back end . 2. Did you try with tcode 'JDBG ' to debug the job . Thanks Kamesh

[ankit_munshi2]

NO - I chose the option - capture jobs.

[kamesh_g]

Go to SM50 . Select your job and menu bar ->Administration ->program -> debugging .

[Mohamed_Mukhtar]

Hi Ankit,

Please follow below steps to know the status of the job :-

1. Goto SM37 ----> Enter your job name and execute

2. Double click on job name --->See Job Details like WP number/PID and Executing Servername

3.Go to SM51--->Double click on servername on which job is running

4.Set filter on PID of the job name

5.See the status of the job, it will show you the table name

6. Double click on the line and it will take you to the select statement which is currently being executed

7.To know which index is being picked by select statment, copy the SQL statement

8.Go to ST05--->select Enter SQL statement--->Paste the SQL statement-->click EXPLAIN. It will show you which index is being used by the select statement.

Hope it helps.

Thanks

[Former Member]

Hi

Yes, you should go to SM50 to debug , select your job name row which is running, then do as as@KAMESH G said, it will stop at the source code where current work process processing.

regards,

Archer

[Mohamed_Mukhtar]

Hi Archer,

To debug a active job, first we need to findout on which application server the job is running.

SM51 is the trasaction to see all active application servers.

Thanks

[vinodkumar_thangavel]

Hi,

U can check the same in SM50.

Regards,

Vinodkumar.