24 lines
997 B
Text
24 lines
997 B
Text
#$Id$
|
|
|
|
#batch process logs every five minutes
|
|
0,5,10,15,20,25,30,35,40,45,50,55 * * * * /opt/apache/htdocs/login/smt/scripts/bin/processlogs
|
|
|
|
#Full-vacuum the TSyslog table if it is less than 10 megs in size or vacuum if the table is 20 megs or less
|
|
3,8,13,18,23,28,33,38,43,48,53,58 * * * * /opt/apache/htdocs/login/smt/scripts/bin/autovac
|
|
|
|
#expire old logs once a day
|
|
6 0 * * * /opt/apache/htdocs/login/smt/scripts/bin/expirelogs
|
|
|
|
#check for hosts who log to this box but are not setup
|
|
2 23 * * * /opt/apache/htdocs/login/smt/scripts/bin/nightlyroguecheck
|
|
|
|
#re-optimize the db at 4am, this recovers deleted space but leaves it allocated on the disk
|
|
#2 1 * * * /opt/apache/htdocs/login/smt/scripts/bin/vacuumdb
|
|
2 3 * * * /opt/apache/htdocs/login/smt/scripts/bin/vacuumdb
|
|
|
|
#rebuild & clean up all indexes at 3am sunday morning
|
|
3 3 * * sun /opt/apache/htdocs/login/smt/scripts/bin/weeklyindexrebuild
|
|
|
|
#every hour re-analyze the whole DB
|
|
59 * * * * /opt/apache/htdocs/login/smt/scripts/bin/analyze
|
|
|