Page History
...
In SQL Workload Analysis you can set your grooming schedule by following these steps:
- Open the file schedule located in 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 in a text editor such as Notepad.
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 2:20 PM, change the time value to 14:20 in a standard cron format. Check the images below.
Tip title Default grooming time By default, the grooming schedule time is set to 1:10 AM every day.
- Restart the SQL Workload Analysis services (IDERA Collector Service and IDERA Framework service).
...