Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open the schedule file in a text editor such as Notepad, this file is located in the following path: C:\Program Files\Idera\IDERA SQL Workload Analysis\etc\mq
  2. Search for the line that specifies the purge schedule in a standard cron format and edit the time value in a 24-hour format. For example, if you want to set your grooming for 8:00 PM of the 14th day of the month, the cron should be set at: 0 20 14 * * in a standard cron format. Check the images below.

    Tip
    titleDefault grooming time

    By default, the grooming schedule time is set at 10:00 AM on the 1st day of the month.

  3. Restart the SQL Workload Analysis services (IDERA Collector Service and IDERA Framework service).



Scroll pdf ignore
SQL Workload Analysis add-on provides a granular breakdown of wait states with easy drill-down to isolate problems quickly.
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...