Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Scheduled Job Table Problem

Former Member

‎2013 Jan 08 7:09 AM

0 Kudos
325

Hi Experts,

                I have a query regarding the job scheduling in sap . In our plant every day 8500 no of job is running . But in the database table TBTCP or TBTCO we are not  getting the jobs  older than 10 days . I have searched in transaction ‘SM37’ , but I am not getting the proper data there also .So my question is that why the data older than 10 days is missing in these two tables ? Is there any other able which contains all the scheduled job data older than 1 year?

 

Thanks and regards ,

Deb

1 REPLY 1

raymond_giuseppi
Active Contributor

‎2013 Jan 08 7:28 AM

153

There are periodic jobs than purge/clean the log in the system, those jobs delete old jobs, old spools, etc. to prevent basis table to become too large. You can check via SM36, standard jobs, look for SAP_REORG_JOBS (Note 784969 - Program RSBTCDEL2), look for the variant used in the job.

Regards,

Raymond

PS: You could also read Note 16083 - Standard jobs, reorganization jobs and Note 706478 - Preventing Basis tables from increasing considerably.