#!/bin/bash

user="CSDWH"
pass="uSr_hwdsc5_pr0d"
db="edwhcg1"
num_server=8

DATA=`date -d "-1 day" "+%Y-%m-%d"`
sql_OK="INSERT INTO MONITOR(NOME_JOB,DATA_ESECUZIONE,ESITO,PARAMETRI) VALUES('DMA_PDF_ENGINE',sysdate,'OK','data:$DATA  ') ";
sql_KO="INSERT INTO MONITOR(NOME_JOB,DATA_ESECUZIONE,ESITO,PARAMETRI) VALUES('DMA_PDF_ENGINE',sysdate,'KO','data:$DATA ') ";


#result=$(echo SELECT DISTINCT SERVER_IP FROM DMA_PDF_ENGINE p , DIM_DAYTIME d WHERE p.daytime_id = d.daytime_id and d.daytime_id =" $DATA  | mysql database -u $user -p$pass
result=8

#sql="
#mysql -u "$user" -p"$pass"  <<EOF
#  use $db;
#  $sql;
#EOF

if [ $num_server = $result ]; then
 echo $sql_OK
else

 echo $sql_KO
fi


#sqlplus -S $user/$pass <<EOF
# SELECT * FROM tableName WHERE username=$var;
# exit;
#EOF