Configuring Query Schedules

You can schedule the execution of your queries and set the frequency of execution.

1. Open the Scheduled Queries page in one of the following ways:
   • Navigate to Management > Advanced Features > Queries > Scheduled.
   • On the Advanced Search page, click > Show as Scheduled Queries.
2. On the Scheduled Queries page, click a query to open its Details pane.
3. On the Details pane, click Edit.
4. On the Edit Scheduled Query page:
   1. To add a schedule, click the + icon or the Add Schedule button. The default schedule name is displayed, but you can change it, if required.
   2. In the Time Frame section, enter the following information.

      Field	Description
      Run	Select one of the following frequency types:
      	Frequency Type	Description
      	Once every few hours	Select the hourly interval from the Hourly Interval drop-down list.
      	Once a day	Select the time of the day from the At drop-down list.
      	Once every few days	Select the number of days from the Interval drop-down list. Select the time of the day from the At drop-down list.
      	Once a week	Select the time of the day from the At drop-down list. Select the day of the week from the Every drop-down list.
      	Once a month	Select the time of the day from the At drop-down list. Select the day of the month from the Every drop-down list. You can also select Last day of the month.
      For the Period	Type the period on which the query should be executed. The default value is -12h. For valid time ranges, see Time Range Expressions.

   3. In the Number of reports to be saved in the system field, enter the number of execution results that you would like to be stored in the system. The default is 3.
      To view the reports stored so far, click View Executions. From the Executions page you can download or delete selected reports. If there is any error while executing the query or sending emails, an error icon is displayed. Hover over the error icon to read the error messages.

      Note: This link is visible only when you are editing a schedule that has already been saved earlier. The link is not available when adding a new schedule.

      
   4. If you want the report to be sent by email, enter the name and email ID of the email recipients and click the check mark to save.
      If a user with the name and email ID is found in the database, the login name of the user is filled automatically in the Login Name field.

      Note: If you do not receive any emails, check if the mail has been redirected to the Spam folder.