background job

[Former Member]

Hi team

yesterday some background jobs have run and huge amount of data is loaded, so now today hw i can list those background jobs which loaded huge data,

feebacks are greatly appreiciated.

Regards

bhaskar

[Former Member · Accepted solution]

Hello,

You can check it from the transaction SM37 ( background job overview) and list all the jobs which ran yesterday night. By checking the job logs and the time each job took to complete, you will be able to find out which job loaded the huge data.

Hope this helps..

Regards,

Jazz

[Former Member · Accepted solution]

Hi

It shows only the duration not the amount of data that is processed.

Regards

Bhaskar

[JPReyes · Accepted solution]

You'll need to check all background jobs in SM37 and check the steps... depending what sort of activity they were doing they'll have a spool attached that might give you indication... in some other cases you'll need to know what the steps did to determinate if they moved/generate data.

Regards

Juan

[Former Member]

thanks for your feedback

[Former Member]

Hi Bhaskar,

You can get the program and variant name from sm37.

Find out what exaclty that Program and Varinat does.

You can run t-code STAD, and select DB req.time (say around 1000 ms) and get the reports who have heavily accessed the database,

Regards

[Former Member]

Hi Bhaskar,

Try this

Goto SM37

Username *

Jobname *

Select Finished,Active,cancelled etc

Give the yesterdays date from and To date column.

You can mention Time duration also.

After that, execute it..

It will display the yesterdays jobs,you can analyze those jobs.

This May Help You.

Best Regards,

Kiranbabu