root/pkg/debian/stratcon.cron.d

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

Deploy a debian compliant crontab for stratcon

  • Property mode set to 100644
Line 
1 #rollup jobs
2 * * * * * postgres /usr/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 * * * postgres /usr/bin/psql -d reconnoiter -U reconnoiter -c "select stratcon.archive_part_maint('noit.metric_numeric_archive', 'whence', 'day', 7);" 1>/dev/null
5 01 00 * * * postgres /usr/bin/psql -d reconnoiter -U reconnoiter -c "select stratcon.archive_part_maint('noit.metric_text_archive', 'whence', 'day', 7);" 1>/dev/null
6 01 00 * * * postgres /usr/bin/psql -d reconnoiter -U reconnoiter -c "select stratcon.archive_part_maint('noit.check_status_archive', 'whence', 'day', 7);" 1>/dev/null
7 01 00 * * * postgres /usr/bin/psql -d reconnoiter -U reconnoiter -c "select stratcon.archive_part_maint('noit.check_archive', 'whence', 'day', 7);" 1>/dev/null
8 01 00 * * * postgres /usr/bin/psql -d reconnoiter -U 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.