Update the ADC sqls per semester
Problem Description :
Updating the ADC(ADM) scripts when requested.
Resolution :
When Janet sends in the SharePoint Upgrade for ADC - login to SharePoint and download the files and place them in a folder on N:\CSD\TRACY\SQL\ADM Create a new folder with the month and year.
There is a READme file that was downloaded with the instructions in it-
You will need to open the parameter file to get the proper parameters for the parameters sql. Use 76000 for the SETID (NOT THE EXAMPLE PROVIDED - 98000)
Go into TOAD - (TEST FIRST) - Then if successfull do it in PROD
Login to TOAD as usgquest with pw.
Open folder and run the three processes using the
NOTE: When the first script CAMPUS_ODS_ADM_ETL_INSTALL... is run it will ask for the tablespace parameter. Enter 'DEVELOPMENT'
Revision Date : 6/29/2017
Keywords : ADC, ADM, Parameters, sql