root/sql/crontab

Revision 30843e711d79e7e70d0c0e014c94bba11cb0b642, 0.9 kB (checked in by Theo Schlossnagle <jesus@omniti.com>, 4 years ago)

fix bugs -- all appears to work as expected now

  • Property mode set to 100644
Line 
1 #rollup jobs
2 * * * * * /opt/pgsql835/bin/psql -d reconnoiter -U stratcon -c "select stratcon.rollup_metric_numeric(rollup) from metric_numeric_rollup_config order by seconds asc;" >/tmp/rollup.log 2>&1
3 #cleanup jobs
4 #01 00 * * * /opt/pgsql835/bin/psql -d reconnoiter -U reconnoiter -c "select stratcon.archive_part_maint('stratcon.loading_dock_metric_numeric_archive');" 1>/dev/null
5 #01 00 * * * /opt/pgsql835/bin/psql -d reconnoiter -U reconnoiter -c "select stratcon.archive_part_maint('stratcon.loading_dock_metric_text_archive');" 1>/dev/null
6 #01 00 * * * /opt/pgsql835/bin/psql -d reconnoiter -U reconnoiter -c "select stratcon.archive_part_maint('stratcon.loading_dock_status_archive');" 1>/dev/null
7 01 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
Note: See TracBrowser for help on using the browser.