Changeset f6540baac0ed25babb2a91d9b715988abb653bcb for sql/crontab

Timestamp:

06/15/09 23:07:39 (4 years ago)

Author:

Theo Schlossnagle <jesus@omniti.com>

git-committer:

Theo Schlossnagle <jesus@omniti.com> 1245107259 +0000

git-parent:

[c87819bbb246f0af528349af329cfbf861ea0afc]

git-author:

Theo Schlossnagle <jesus@omniti.com> 1245107259 +0000

Message:

flag-day(stratcond,database) partition the loading docks, refs #140

Files:

• sql/crontab (modified) (1 diff)

sql/crontab

@@ -6 +6 @@
-03 00,06,12 * * * /opt/pgsql835/bin/psql -d reconnoiter -U stratcon -c "select stratcon.rollup_matrix_numeric_12hours();" >/tmp/rollup_12hours.log 2>&1
-#cleanup jobs
+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
+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
+01 00 * * * /opt/pgsql835/bin/psql -d reconnoiter -U reconnoiter -c "select stratcon.archive_part_maint('stratcon.loading_dock_status_archive');" 1>/dev/null
-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