Automate a process of Copying or refreshing QAS data with PRD data

Database
Enthusiast

Automate a process of Copying or refreshing QAS data with PRD data

Hi Teradata gurus,

 

Environment: TD 15.10. TARA and Netbackup on a Windows server. Database resides on Suse Linux server.

 

I refresh certain number of tables in QAS with PRD data every other week.

 

First, I run an Archive job to make a backup of the PRD tables. Then, I get the sourceid from the archive job and plug into the COPY job and run.  

Running the archive job and plugging the sourceid to the copy job and running the copy job are handled manually.

 

Is there a way to automate this process? The most challenge I have is to plug in the sourceid I get from the archive job to the copy job.

 

Has anyone automated this refresh process? Could you share how you do it?

 

Thank you,

 

James