root/sql/crontab

Revision 3be398539c4bcd0e77acf4390c6dda1635329b58, 0.6 kB (checked in by Theo Schlossnagle <jesus@omniti.com>, 6 years ago)

people are gonna need this crontab to see rollups

  • Property mode set to 100644
Line 
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
Note: See TracBrowser for help on using the browser.