Background jobs backup

[Former Member]

Hello Guys,

We have a monthly refresh in RTP environment and I want some BG jobs nearly 20, not to be deleted during this course. Kindly suggest how to protect themn from getting deleted!

Ram

[Former Member]

Hi Ramakrishna,

There are couple of ways to do it.

Procedure 1

1). Export all the BG job tables from DB and after the system copy, delete the tables from the new DB and import the old tables with exported .DMP file.

Exported tables are created in the form of .DMP file.

Here is the procedure

D:\> exp

username :-

pwd

Export FIle : file name

2)Users 3) Tables > T

Export table Data - Yes

Compress Contents - Yes

and Export the tables TBTCA, TBTCB, TBTCCNTXT, TBTCCTXTT, TBTCCTXTTP, TBTCI, TBTCJSTEP, TBTCO, TBTCP, TBTCR, TBTCS, VARID, VARI, VARIT, VARIS

and import the above created .DMP file after the system copy.

2) Procedure

You can export the jobs based on client and import it back as Varun said.

Thanks,

Sravanthi

[Former Member]

Hi,

The best way to retain your old jobs and their scheduling would be to write ABAP program to export and import jobs - which is not a difficult task.

Tables BTCCTL, BTCDELAY, BTCEVTJOB, BTCH1000, BTCH1010, TBTCO and TBTCP store the background job details.

You may also use third party tools to acheive this.

Also read SAP Note 31503 - FAQ: Background jobs

For details regarding script, please read.

Hope this answers your question.

Regards,

Varun