Last crontab

# /etc/crontab: system-wide crontab
# Unlike any other crontab you don't have to run the `crontab'
# command to install the new version when you edit this file
# and files in /etc/cron.d. These files also have username fields,
# that none of the other crontabs do.

SHELL=/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin

# m h dom mon dow user command
17 * * * * root    cd / && run-parts --report /etc/cron.hourly
25 6 * * * root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )
47 6 * * 7 root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.weekly )
52 6 1 * * root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.monthly )
55 12,17,20,23 * * 0-6 root /var/jhcis/mysql-backup-jhcisdb.sh >/dev/null 2>&1
0 0-23 * * 0-6 root sh /var/jepidem/runjepidem.sh >/dev/null 2>&1
0 0-23 * * 0-6 root sh /var/jxp18/runjxp18.sh >/dev/null 2>&1
0 0-22 * * 0-6 root sh /var/jautoup/runjauto.sh >/dev/null 2>&1
*/5 * * * * root sh /var/jhcis/create-pdf.sh /dev/null 2>&1
#end

lastest jhcis backup

# !/bin/sh

sudo mysqldump --skip-comments --default-character-set=utf8 --routines --lock-tables=false --compatible=no_key_options -u root -p123456 jhcisdb > /home/jhcis/backupjhcis/jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/backupjhcis/jhcisdb-03301.$(date -d "-31 day" "+%Y-%m-%d").sql

sudo mysqldump --skip-comments --default-character-set=utf8 --routines --lock-tables=false --compatible=no_key_options -u root -p123456 jhcisdb > /home/jhcis/Dropbox/backupjhcis/jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/Dropbox/backupjhcis/jhcisdb-03301.$(date -d "-7 day" "+%Y-%m-%d").sql

mysql query script

https://drive.google.com/drive/folders/1VP9TPvL7w1EMibp3mvS8y0h155Q7ah9z?usp=sharing