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 |
|
Edit Schedule |
Click |
| 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 schedule a new query. For more information, see 
to edit a scheduled query from the list.
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
-
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.
- 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.
- 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.
- 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.
- Pattern (of days or week or month):
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. - Date/Time - You can schedule the date and time on which you wish to run the job by clicking this