Page Comparison

...

1. Take a backup of table EsrNotification in tcs database.
2. Take a backup of table EsrNotificationDetailsRecord in ESR database.
3. The full notification should be triggered after the daily applicant and notification jobs are finished. The last one starts at 5.30PM. Ideally and if time permits it is good to do it over weekend as there is not much of user interactions with the TIS application. 
   1. The implication of running full notification results in duplicate high volume of applicant records generated during applicant export. 
4. Run the job https://build.tis.nhs.uk/jenkins/job/tis-esr-etl-full-notification/ with the below options selected:

   1. PLATFORM: prod

      (

      Info
      whichever environment you want the full load to run

      )

      
      

   2. OFFICE: Put the name of the  deanery code you want to run the full load against.

   3. ESR_APP_LOG_LEVEL: Change it to DEBUG if you want to monitor the logs. Otherwise leave it as INFO.

5. The jenkin job finishes after triggering the esr-etl load. ssh to the environment and grep the esr-etl log to see the progress of the load.

heetis@HEE-TIS-VM-STAGE-APPS-GREEN:~$ docker ps -a|grep esr-etl
83729acdb151        repository.tis.nhs.uk:5000/hee/esr-etl:1.0.22.Final                             "java -XX:+UnlockE..."   7 minutes ago       Exited (0) 6 minutes ago                                                      esretl_esr-etl_1
heetis@HEE-TIS-VM-STAGE-APPS-GREEN:~$ docker logs esretl_esr-etl_1

Once the job finishes you should see a DNF file generated and uploaded to the corresponding Azure account inside the <currentDate>-outbound folder.