I combined some command in bash so I can get what I want. The date command giving the ping output a timestamp. While the ‘tee’ will put the result into the log file.

Here is my bash script to execute msyql command !/bin/bash tglblk=$(date –date=”8 days ago” +%Y-%m-%d) tglhapus=”$tglblk 23:00:00″ SQL=”DELETE FROM Events WHERE EndTime<=’$tglhapus’;” MYSQL_USER=”root” MYSQL_PASS=”” MYSQL_DB=”mydb” echo $SQL | mysql –user=$MYSQL_USER –password=$MYSQL_PASS $MYSQL_DB Then I put it into crontab to run at specific time.