Scheduling a Query

Schedule tab

This tab displays a list of scheduled queries if any. It lets you run the queries automatically at your scheduled time intervals. The toolbar displayed on the Schedule tab allows you to perform these operations, based on your privileges:

Operation

Description

Create Schedule

Click to schedule a new query. For more information, see Scheduling a Query.

Edit Schedule

Click to edit a scheduled query from the list.
View Schedule
Click to view a scheduled query from the list.
Note: Read-only information is displayed.
Copy Schedule Click to copy a scheduled query from the list.
Delete Schedule

Click to delete a scheduled query from the list.
You can also choose to sort your scheduled queries on the Name, Trigger, and Next Run fields. Moreover, if you have an extensive list of scheduled queries, you can filter your queries using the Filter field.
The details displayed on this page are as follows:

Field

Description

Name

The name of the scheduled job.

Query Name

The name of the query.
Scheduled By

The user who has scheduled the query.
Trigger The status of the scheduled query, such as enabled or disabled. While scheduling a query, if the Schedule field is toggled to ON, the status is shown as Enabled, and if toggled to OFF, the status is shown as Disabled.
Next Run

It displays the next scheduled run date and time.
Last Run It displays the last scheduled run date and time.

Scheduling Query

To schedule a query to run automatically at your scheduled time intervals, perform these steps:
Note: You must have the CRUD rights to create, view, edit, or delete the scheduled queries.
  1. On the Spectrum Discovery menu bar, click Query.
    The Query page is displayed.
  2. On the Schedule tab, click the Create Schedule button.
    The Create Schedule page is displayed. On this page, define these fields:

    Field Name

    Description

    Name

    Enter a name for your scheduled job in the Name field.

    Query Name

    Select a query from the drop-down list for which you wish to schedule the job.

    Schedule Section
    Select any of these time trigger from the drop-down list:
    • Date/Time - You can schedule the date and time on which you wish to run the job by clicking this button.
    • Recurring Date/Time - You can schedule a recurring date and time event for your job.
      Note: When you select this option, Pattern, Time, and Range sections appear below the trigger. Use these for setting up a recurring job, as described below.
      1. Pattern (of days or week or month):
        • Every weekday: To run the job on every day of the week.
        • Every: At a specified periodicity. For example, to run a job every alternate day, choose this option, and enter 2 in the selection box.
        • Day <> of every <> month(s): To run a job on a specified day and month. For example, to run a job on the third day of every alternate month, enter 3 in the Day selection box and 2 in the month(s) selection box.
        • Every <> month(s) <on a specified day> <of a week>: For example, to run the job every third month on the second Tuesday, enter 3 in the month(s) selection box, and from the dropdowns, select on the second and Tuesday options respectively.
        • Days of the week: Select the days of the week on which you want to run the job.
          Note: You can select multiple days.
      2. Time: To run the job at a specified interval of time, select this option and, in the selection boxes, specify the number of hours or minutes after which you want to run the analysis. For example, every three hours.
      3. Range: To specify the range of analysis for the job (at a specified time between a range of dates), select the Start date and End date from the respective calendars and select the time.
        Note: Select the No end date checkbox if you do not want to specify an end date for the recurring job.

    Schedule

    Toggle the Schedule button to ON or OFF to enable or disable the schedule based on your requirements. If the Schedule button is toggled to ON, the status is shown as Enabled, and if toggled to OFF, the status is shown as Disabled, on the Schedule home page.

    Parameters

    It displays the default set of parameterized values based on the query you choose. You can choose to create different schedules on a different set of parameters. For example, different users can create schedules for the same query using a different set of parameters.

    By using different parameters, a parameterized query returns different results. For more information, see Creating Parameterized query section in Creating a Query.
    Export Details It allows you to export the query results to your selected location. For more information about exporting the query results, see Exporting a Query.
    Note: It is mandatory to select a file path to export a query. In case you copy the scheduled job, the file path will not be copied, and you will have to define a new path.
  3. After you define the fields, click Save.
    The scheduled query is displayed on the Schedule home page.
    Note: When a query is scheduled, the query and its parameters are saved along with the schedule details. If this query is updated, it will not reflect in the schedule unless the schedule is updated, and the query is selected again to pull the updates.

    In case the schedule is not updated after the query update, it will keep running with the initially saved query.