# CRON EXAMPLE
#
# 0..59    0..23    1..31  1..12   0..6
# minute   hour     date   month   day
########################################################################
# TOO MANY REQUESTS:
# This runs a report that shows if there are > 20 concurrent requests
# backed up in any queue.  Queues may back up because a user kicks off
# a large number of requests, or because a request is taking a very 
# long time to run.  You'll have to gauge whether it is just a lot of
# requests being submitted at once, or one or two long-winded requests
# keeping the other requests from running.  Look at hogtracker and 
# locktracker for guidance...The message passed to the pager would 
# look like: 91121 (there are 21 requests pending in one of the
# queues)
0,10,20,30,40,50 8-18 * * 1-5 /usr/local/scripts/vtk_run_high_requests.sh > /dev/null 2>&1
########################################################################
# DELETE UDUMP TRC FILES:
# deletes trace files from udump area that are older than 7 days
30 21 * * * find /apps/bin/oracle/admin/prod/udump -name \*.trc -mtime +7 -print -exec rm {} \; > /dev/null 2>&1
########################################################################
# DELETE BDUMP TRC FILES:
# deletes trace files from bdump area that are older than 1 month
30 21 * * * find /apps/bin/oracle/admin/prod/bdump -name \*.trc -mtime +31 -print -exec rm {} \; > /dev/null 2>&1
########################################################################
# DELETE AUDIT TRAIL FILES:
# deletes audit trail information that is older than 1 month.  
30 21 * * * find /apps/bin/oracle/admin/prod/adump -name \*.aud -mtime +31 -print -exec rm {} \; > /dev/null 2>&1
########################################################################
# DELETE FILES FROM /var/tmp OLDER THAN 3 DAYS
# These are the temporary files created when users use SQL*FORMS or
# SQL*REPORTWRITER... if a request 'loses its way' or is cancelled,
# Oracle doesn't always clean up after itself the way it should, leaving
# large old files that should be deleted since they are no longer needed
# Note that we moved this temporary space from /var/tmp to 
# /apps/bin/fin/tmp because we kept running out of space using the
# default.  You make this change in your APPLSYS.env file.  If you
# never run out of space, then leave it alone and run this against
# /var/tmp
15 23 * * * find /apps/bin/fin/tmp -name \* -mtime +3 -print -exec rm {} \; > /dev/null 2>&1
#######################################################################
# LOCKTRACKER and HOGTRACKER and RUNTRACKER:
0,5,10,15,20,25,30,35,40,45,50,55 * * * * /usr/local/scripts/locktracker.sh > /usr/local/scripts/locktracker.temp1
0,5,10,15,20,25,30,35,40,45,50,55 * * * * /usr/local/scripts/hogtracker.sh >  /usr/local/scripts/hogtracker.temp1
0,5,10,15,20,25,30,35,40,45,50,55 * * * * /usr/local/scripts/runtracker.sh > /dev/null
#
# CLEAN UP HOGTRACKER/LOGTRACKER/RUNTRACKER:
# Added by Mark Stevens 4/4/96:
# Keep tracker history files down to reasonable size.
3 0 * * * tail -10000 /usr/local/scripts/hoghist  > /usr/local/scripts/hoghist2;  mv /usr/local/scripts/hoghist2  /usr/local/scripts/hoghist  2>&1
3 0 * * * tail -10000 /usr/local/scripts/lockhist > /usr/local/scripts/lockhist2; mv /usr/local/scripts/lockhist2 /usr/local/scripts/lockhist 2>&1
3 0 * * * tail -10000 /usr/local/scripts/runhist  > /usr/local/scripts/runhist2;  mv /usr/local/scripts/runhist2  /usr/local/scripts/runhist  2>&1
#############################################################################
# MAKE SURE /apps/bin/fin DOESN'T GET FILLED UP
# Tis script is meant to keep a close eye on /apps/bin/fin.  When
# it reaches 85% or greater, it will mail a notification to select
# personnel.  This script also pages select personnel and passes the 
# number 8500 as well as the percentage of apps/bin/fin used to their pager.
# For example, if apps/bin/fin reaches 90%, then the page received
# should look like this: 850090.
1,15,30,45 0-23 * * 0-6 /usr/local/scripts/var_cap_HP  > /dev/null 2>&1
####################################################################