SM37 and SM35 - how to reconcile

[Former Member]

Hello,

I have three background jobs that ended in error. These are Z programs. They were scheduled to run at the same time. Logs are not clear on which is which. Is there an ID that can be related to SM37 jobs' info? I see ID in SM37's job details for the job, for example: ID: 10490900, but in SM35 for this job I see Queue ID:10110207004430473232 and TemSE ID: BDCLG443047323235823. No connection to this job ID in SM37...

Which tables SM35 works off?

Thanks

Glaina

[Former Member]

old question

[karthik_narayan2]

Hi,

I am working on automating the background job monitoring done via SM37.

Can you please help me in finding the table name holding the field values for Duration and Delay.

Thanks,

Karthik

[Former Member]

Hi There,

I had automated the ST22 report from database level itself. but yet to do this sm37 automation.

Regards

Saibaba

[Former Member]

The SM37 job information is stored in tables TBTCP, TBTCO & TBTCS.

The SM35 session information is stored in tables APQD & APQI.

- Regards, Dibya

[Former Member]

Dibya,

Thank you for your reply. I reviewed tables but I am not able to figure out which field in any of SM37 tables can help me to find entry in any of SM35 tables.

Thanks

Galina

[Former Member]

There won't be any correlation as SM35 has SESSION-ID's & SM37 has JOB-ID's.

Did you schedule batch jobs by BDC?

- Regards, Dibya