Accidentally Deleted all the background Jobs in the system

[Former Member]

Hello Masters,

In one of the systems, some one deleted all the Background jobs. Now there is a situation to restore thsi situation (Schedule all teh Jobs properly as it was there in the past), can some one suggest how we can achive that?

Thanks & Regards

SAP Basis Engineer

[former_member524429 · Accepted solution]

Hi,

Standard jobs can be rescheduled using SM36 -> Standard Job wizard with use of this SAP Note 16083 - Standard jobs, reorganization jobs.

Other no-standard / User-defined Back ground jobs information you can get by searching for the old background jobs/job logs using SM37 or you can get that info from the following Tables and reschedule them accordingly. Use se16 and vies the last run of all Background jobs with -variants information from the following tables.

TBTCO - Job Status Overview Table

TBTCP - Background Job Step Overview

Regards,

Bhavik G. Shroff

[volker_borowski2]

Hello,

if the system has not been too busy since the deleteion,

you can try to copy a former version of tables TBTCS / TBTCO

to backuptables utilizing Flashback Query.

937492 - FAQ: Oracle Flashback

Shows you some information about this feature.

Basicly, you have to determine the Timestamp of the delete,

create table ZBAK_TBTCO

as select * from TBTCO as of timestamp....

and you will have a copy of the table from an earlier timestamp.

If you are lucky, the info is still in UNDIO.

If not, you have to restore to a sandbox and do the queries there.

Then Query the backup tables to determine what jobs had been

scheduled at this time. Then you have to re-schedule them manually.

For no reason, you should blindly re-insert entries from the backup table

to the original Table as important secondary tables will not be restored with

this procedure. It will only give you the opportunity to calculate the

amount of damage.

Hope this helps

Volker