1.3.3a

Owned by Cyrus Hiatt (Unlicensed)
Last updated: Jan 07, 2019 by Samuel Valdez
1 min read

Preamble

  • notify all stake holders before the release.
  • eas commit id:  55cab733f98a

  • config commit id: ba154b3a5042

Database Backup

Log onto the SF DB and back up the databases. The exact command line resides in the postgres user crontab.

sudo -u postgres -i
crontab -l
/home/dba/scripts/dbbackup.sh > /var/tmp/dbbackup.log

Deploy Automation Scripts

Deploy new code to automation server.  Remove the following two directories:

c:\apps\eas_automation\automation
c:\apps\eas_automation\database

Then run the deploy script like so:

cd C:\apps\
python eas_automation_deploy.py eas_automation 

Keep your session open because you will use the automation scripts to send the release notification at the end.

Add Scheduled Tasks

Add the bulkloader_etl job to the production etl task scheduler: The bulkloader_etl job should run every weekday at 11:45 PM.  This is a suitable time because it follows the COMMIT parcels at 10:15 PM and COMMIT streets at 11:15 PM, and based on the Task Scheduler history, COMMIT streets does not require more than a minute to complete.

Details for setting up the task in the Task Scheduler
Name         run_job EXECUTE bulkloader_etl SF_PROD
Program      C:\apps\eas_automation\automation\bin\run_job.cmd
Arguments    EXECUTE bulkloader_etl SF_PROD
start in     C:\apps\eas_automation\automation\bin\


Done!