MAILTO=sysadmin@royaltyshare.com
# rebuild the aggregate sale tables for all clients
0 22 * * *      /app/tools/stats/bin/build_all_client_sale_aggregates.pl
# backup the db's
0 0 * * *      /app/tools/dbadmin/bin/dump_databases.sh >> /app/tools/sysadmin/log/dump_databases.log 2>&1
# remove old db backups
0 1 * * *   find /app/backup/snapshots/ -mtime +6 -exec rm -rf {} \;
# check disk space
0 2 * * *       /app/tools/sysadmin/bin/lowspace -i 90 -d /dev/mapper/VolGroup00-LogVol00
# automap unmatched records for all clients
1 1 * * *   /app/tools/sale_import/bin/match_again.pl -c all -m
# copy the db backups to raptor02
0 3  * * *   find /app/backup/snapshots/ -mtime -1 -exec scp {} wwwadmin@10.10.10.11:/backup/raptor01/snapshot/ \;