Background Job is taking long time to finish

[Former Member]

Hello All,

In our Production system one Background Job is running Since long time(4 hr's),Normalyy it should finsh with in one hour.

System prformance is good and all background work process are also free.

My question is whay the background Job is taking more time......?

Can any one help us, what are the possible reasons for this issue

Thanks&Regards,

Praveen.

[former_member197561 · Accepted solution]

Hi,

Use SE30 to attach to the work process (option "In Parallel Process") and get snapshot to see what activities are ongoing.

Best regards,

Sylvia

[former_member66264]

Do you see something special in SM50?

I see 2 options :

Jump in in DEBUG mode to see what it is doing

Trace it via ST12 and check from there where the long time is comming from

[former_member66264]

Do you see something special in SM50?

I see 2 options :

Jump in in DEBUG mode to see what it is doing

Trace it via ST12 and check from there where the long time is comming from

[Former Member]

- Check if it is a Z program and tune if it is necessary

- Check ST03N to find out what is causing the problem

- You can run the performance trace by ST05

- check if statistics is up to date.

[former_member182114]

Hi Praveen,

Maybe the job went down w/o update the job table info.

Go to SM37, select the line o job and click on Job -> Check Status (CtrlShiftF12).

Regards, Fernando Da Ros

[Former Member]

Hello Fernando Da Ros

Thanks for the Reply

I Checked the status of the Job ,it is running fine.

Regards,

Praveen.

[Former Member]

Hi,

What kind of job it is!!

Can you check the work process overview in SM66, wether any of the background wp is going for any sequential read, if yes--which table and is the SQL explain plan is good enough..if not can we optimise it?

You can also check the ST06 --Detail analysis --> compare recent day --> CPU load. Are the CPU utilisation fine.

Please check all these things if you could able to find the root cause of the problem.

Thank you,

Tilak