#!/bin/sh

source /app/tools/common/lib/.shell_globals

EXEC=1

dd=$(date "+%Y%m%d")
yy=$(date "+%Y")
mm=$(date "+%m")

odir="/mnt/mysql/stats/schema-imports/logs/${dd}"

logit "Start $(date)"

start_time=$(date +%s)

runit "mkdir -p ${odir}" 

runit "cd /app/tools/admin/cron/stats";

runit " \
mysql --login-path=admin -D report -Ne \"select db_name from d_db where calc_stat=1 order by 1\"| \
parallel -j 8 \"./redshift-cp-mysql.pl -d {} 1>${odir}/{}.redshift-cp-mysql-${dd}.log 2>&1\" \
"
end_time=$(date +%s)
elapsed=$(( end_time - start_time ))

logit "Complete $(date) - ${elapsed} secs elapsed "