SOP for Initiating Data Transfer from PTC to DW

Please forward this as needed to whomever needs to have thisinformation.  We have this documented in RKL’s documentation, and here itis per your request.  I’m hoping David Hall can provide you with thecredentials for the users mentioned below, but if not, please let me know andwe can share them with you securely.

• Connect to PROD DW:  10.0.0.146 // AgronDW
  • Use “sa” credentials
• Confirm ETL has completed

select top 10 *

from PTC_LoadHistory

order by PTCLoadKey desc

• Once you see the top record shows StagingTableLoadComplete = 1, then you can proceed.
• Start the Job in SQL Server Agent labeled as: “DW: Check PTC Load and Run ETL”
  • This will take about 5 minutes
• Remote Desktop into 10.0.0.76 as “agron\sqluser2”
  • OpenTask Manager and run each of the non-disabled jobs; sort by “next run time” toensure they run in order

• Single left click the job you want to run, then click “Run” on the right side menu; the Status will update to “Running”
• Click “Refresh” on the right nav to update the status; Ensure the task completes by waiting until the status says “Ready” before you start the next job.