cancel
Showing results for 
Search instead for 
Did you mean: 

Retain background jobs and its variants before system refresh activity

former_member190251
Participant
0 Kudos

Hello All,

I am going to perform system refresh activity on quaity system on monday. Customer wants to retain the background jobs and its variants in the quality system. Please guide me and let me know the steps to retain the background jobs and its variants before starting the system refresh activity.

Regards

Subbu

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi,

Tthere is a way to suspend/pause the running/active jobs, you have to stop/cancel those ones.But you can use the program BTCTRNS1 to suspend/deschedule all the scheduled jobs,ie  Move Jobs with Status "Rescheduled due to Upgrade"

,use program BTCTRNS2  Release jobs with status "Descheduled due to upgrade".

Regards,

Sachin.S

former_member188883
Active Contributor
0 Kudos

Hi Subbu,

Post refresh you may be able to retain the background job information but not the program variants.

I am not sure why do you need to retain the job variants even though data is already overwritten from source system during refresh ?

Hope this helps.

Regards,

Deepak Kori

willi_eimler
Contributor
0 Kudos

Dear Subbu,

You have to export the TBT* Tables to retain the jobs. You can do this with R3trans:

1. Make Export file
2. Make Import file
3. Make Export in Q System before Systemcopy

4. Start Database and not SAP
5. Make Import in Q after Systemcopy

6. Start sap


1. Make Export file /tmp/export_cmd
export
file='/tmp/export_Q.dmp'
client=<your client>

delete from TBTCA               
delete from TBTCB               
delete from TBTCCNTXT           
delete from TBTCCTXTT           
delete from TBTCCTXTTP          
delete from TBTCI               
delete from TBTCJCNTXT          
delete from TBTCJSTEP           
delete from TBTCO               
delete from TBTCO_V01           
delete from TBTCP               
delete from TBTCPV              
delete from TBTCR               
delete from TBTCS               
delete from TBTC_SPOOLID        
delete from BTCEVTJOB

                                
select * from TBTCA             
select * from TBTCB             
select * from TBTCCNTXT         
select * from TBTCCTXTT         
select * from TBTCCTXTTP        
select * from TBTCI             
select * from TBTCJCNTXT        
select * from TBTCJSTEP         
select * from TBTCO             
select * from TBTCO_V01         
select * from TBTCP             
select * from TBTCPV            
select * from TBTCR             
select * from TBTCS             
select * from TBTC_SPOOLID 

select * from BTCEVTJOB

2. Make Import file /tmp/import_cmd
import
file='/tmp/export_Q.dmp'


3. Make Export in Q System before Systemcopy
R3trans -w /tmp/Q_export.log  /tmp/export_cmd

4. Start Database and not SAP

sqlplus "/as sysdba"

SQL> startup

or

startsap

stopsap r3

5. Make Import in Q after Systemcopy
R3trans -w /tmp/Q_import.log  /tmp/import_cmd

If you want to undo this, start the export script in P system and the Import script in Q system.

Don't be afraid of the delete statement but without delete it doesn't work!

6. Start sap

startsap

Best regards
Willi Eimler

former_member190251
Participant
0 Kudos

Hi Willi Eimler,

Thanks for your reply,

Will it retain variants of the background jobs?

Regards

S.Subramani

willi_eimler
Contributor
0 Kudos

Hi Subbo,

did you mean Variants of reports (= Variants of the reports in Jobsteps)? Then you have to export/Import Table VARI too!

I never exported/imported Variants. Can you feedback the result, when you do it?

Best regards

Willi Eimler

Former Member
0 Kudos


Hi,

I think it's quite diffcult to get the batch jobs back into the system becuase when we refresh the system it will refresh entire system i.e users,transaction data,programs tables e.t.c. that time system refresh the variants and jobs as well.

the the all the jobs first before data refresh and check the diff.

Regards,

Raman

Former Member
0 Kudos

Hello,

here are some similar threads, try to walk through them (both are about report BTCTRNS1):

And here you can learn how that report exactly works:

Hope it helps, kind regards