Schedule Database Maintenance

From WebWatchBotWiki
Jump to: navigation, search
 Share 

Summary

Difficulty: Beginner

This article focuses on setting up two different maintenance schedules. This tutorial has two parts:

  1. This example will show how to set up a maintenance period for All Watch Items, once a week for a duration of 20 minutes for the next 10 years. Scenario: Many organizations will perform a server backup at scheduled times for the server running WebWatchBot.
  2. Daily maintenance period for 5 minutes, every day, for one Watch Item for the next 10 years. Scenario: One monitored website goes offline for 5 minutes each day for routine maintenance.


Part 1 - Schedule Weekly Database Maintenance

This section will guide you through the steps to scheduling weekly database maintenance. Database maintenance will be scheduled to run every Sunday morning between 1 am and 1:20 am.

  1. Select the “Scheduler” shortcut in WebWatchBot Manager (lower left-hand corner of the screen)
  2. Create a new Scheduled Item for “All Watch Items”.
    1. Create a new Scheduled Item: In WebWatchBot Manager, select the menu item "File" -> "New" -> "Scheduled Item" (Ctrl-N) or click the "New" icon on the toolbar.
    2. The "Schedule Item" window will appear.
    3. Select the Watch Item "All Watch Items" from the Watch Item dropdown list.
  3. Click the "Type Settings" button. The "Schedule Database Maintenance" window will appear.
  4. Check the box for "Compress and Repair Database". This will ensure a high level integrity for your data.
  5. Check the box for "Remove Records Older than"
  6. Change the value for months from 1 to 3. If you are collecting a large amount of data or wish to save a longer period of historical data, increase or decrease this value accordingly. The settings should look like the following:
    tut_schedule_maint1.png
  7. Click OK to close the "Schedule Database Maintenance" window.
  8. Set the start date for some future date and the end date should be 20 minutes after that. This will create a maintenance period of 20 minutes and that the user would use this type of timeframe to ensure that WebWatchBot will not run during this time so that routine maintenance tasks, i.e. backups, scheduled downtime, etc. will not trigger false positives.For example :
    tut_schedule_maint2.png
    1. In the "Schedule Date and Time" section, in the "Start" field enter "28 Sep 2008 10:00 pm"
    2. In the "End" field, enter "28 Sep 2008 10:20 pm"
  9. Set the recurrence pattern to "Weekly". Pick any day of the week.
  10. Set the end for 10 years

Please note: during maintenance all Watch Items and Transactions will not run: no alerts will be sent during this time

Part 2 - Scheduling Daily Database Maintenance for a Single Watch Item

This section will guide you through the steps to scheduling daily database maintenance for a single watch item. Database maintenance will be scheduled to run daily for 5 minutes.

  1. Select the “Scheduler” shortcut in WebWatchBot Manager (lower left-hand corner of the screen)
  2. Create a new Scheduled Item for one Watch Item
    1. Create a new Scheduled Item: In WebWatchBot Manager, select the menu item "File" -> "New" -> "Scheduled Item" (Ctrl-N) or click the "New" icon on the toolbar.
    2. The "Schedule Item" window will appear.
    3. Select the Watch Item from the Watch Item dropdown list.
  3. Set the start date for some future date and the end date should be 5 minutes after that. This will create a maintenance period of 5 minutes and the user would use this type of timeframe to ensure that WebWatchBot will not run during this time so that routine maintenance tasks, i.e. backups, scheduled downtime, etc. will not trigger false positives for a particular web site. For example :
    tut_schedule_maint3.png
    1. In the "Schedule Date and Time" section, in the "Start" field enter "28 Sep 2008 10:00 pm"
    2. In the "End" field, enter "28 Sep 2008 10:05 pm"
  4. Set the recurrence pattern for daily
  5. Set the end for 10 years


The above time is just an example, you can set it according to your requirements.