Changeset ea0809f5e7f454f5e874bca7d79be8e2d6a10789

Show
Ignore:
Timestamp:
12/03/08 17:37:57 (5 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1228325877 +0000
git-parent:

[f6f7270ca79b3c5175ca4787e594b761c8a94e4c]

git-author:
Denish Patel <denish@omniti.com> 1228325877 +0000
Message:

Added job to cleanup prism.saved_graphs table with saved_graphs=false.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/crontab

    r3be3985 rea0809f  
    1 * * * * * /opt/pgsql831/bin/psql -d reconnoiter -U stratcon -c "select stratcon.rollup_matrix_numeric_5m();" 
    2 00,10,20,30,40,50 * * * * /opt/pgsql831/bin/psql -d reconnoiter -U stratcon -c "select stratcon.rollup_matrix_numeric_20m();" 
    3 01,31 * * * * /opt/pgsql831/bin/psql -d reconnoiter -U stratcon -c "select stratcon.rollup_matrix_numeric_60m();" 
    4 02 00,03,06,09,12,15,18 * * * /opt/pgsql831/bin/psql -d reconnoiter -U stratcon -c "select stratcon.rollup_matrix_numeric_6hours();" 
    5 03 00,06,12 * * * /opt/pgsql831/bin/psql -d reconnoiter -U stratcon -c "select stratcon.rollup_matrix_numeric_12hours();" 
    6  
     1#rollup jobs 
     2* * * * * /opt/pgsql835/bin/psql -d reconnoiter -U stratcon -c "select stratcon.rollup_matrix_numeric_5m();" >/tmp/rollup_5.log 2>&1 
     300,10,20,30,40,50 * * * * /opt/pgsql835/bin/psql -d reconnoiter -U stratcon -c "select stratcon.rollup_matrix_numeric_20m();" >/tmp/rollup_20.log 2>&1 
     401,31 * * * * /opt/pgsql835/bin/psql -d reconnoiter -U stratcon -c "select stratcon.rollup_matrix_numeric_60m();" >/tmp/rollup_60.log 2>&1 
     502 00,03,06,09,12,15,18 * * * /opt/pgsql835/bin/psql -d reconnoiter -U stratcon -c "select stratcon.rollup_matrix_numeric_6hours();" >/tmp/rollup_6hours.log 2>&1 
     603 00,06,12 * * * /opt/pgsql835/bin/psql -d reconnoiter -U stratcon -c "select stratcon.rollup_matrix_numeric_12hours();" >/tmp/rollup_12hours.log 2>&1 
     7#cleanup jobs 
     801 00 * * * /opt/pgsql835/bin/psql -d reconnoiter -c "delete from prism.saved_graphs where saved = false and last_update<current_timestamp - '1 day' ::interval;" 1>/dev/null