New Cache Dialog Box Properties
This topic describes how you can use the New Cache dialog box to create a schedule task to generate cached report data for the specified data resources.
Server displays the dialog box when an administrator selects New Cache in the Administration > Configuration > Cache > Data Cache page on the Server Console.
The dialog box includes two phases, one for selecting data resources and the other for defining the schedule task.
Selecting Data Resources Phase
At this phase, you need to specify the data resources for which you want to create cached data.
Select a Folder
Specify the folder in the server resource tree that contains the required catalog. You can select the ellipsis button to open the Select Folder dialog box for selecting the folder.
Select a Catalog
Select a catalog in the folder.
Select Queries
Server lists the selected data resources.
- Add button
Select to open the Select Queries dialog box to select the data resources that you want to create data caches for. - Remove button
Select to remove the selected data resources.
OK
Select to go to the next phase to define the schedule information.
Cancel
Select to close the dialog box without creating a data cache.
Help
Select to view information about the dialog box.
Defining the Schedule Task Phase
At this phase, you need to define the data resource information and the updating policy of the data cache on these tabs:
Back
Select to go back to the previous tab.
Next
Select to go to the next tab.
Finish
Select to create the data cache.
Cancel
Select to return to the selecting data resources phase without saving any changes.
Help
Select to view information about the dialog box.
General
Before scheduling a CRD task, you need to configure the settings in this tab first.
Select Query
Server lists all the query resources you selected in the Selecting Data Resources Phase. Select a query resource from the list, and then specify the general properties of its scheduled CRD task.
Specify the values of the parameters you want to apply to the selected query resource. You may specify parameter values in these ways.
If the query resource does not have parameters, Server displays "No Parameter Needed" here.
Cached Report Data Info
Specify the data cache information.
- Name
Name of the selected query resource. Server also uses it as the name of the new data cache. - Data Source
Data source in which the query resource is. - Catalog
Path of the catalog in which the query resource is. Server uses the latest catalog version by default. - Type
Type of the query resource. - Priority
Specify the priority level of the scheduled task. The priority levels are from 1 to 10 in ascending order of lowest priority to highest priority. By default, Server ignores this property unless you modify server.properties in<install_root>\bin
to set queue.policy not equal to 0.
Advanced
Configure some advanced settings.
- Connect to [Data Source Name]
Specify the DB user and password for connecting to the data source.- Use the DB user and password defined in catalog
Select if you want to use the DB user and password defined in the catalog. - Use the DB User
Select this property, and you can then specify another DB user and password instead of the one defined in the catalog.
- Use the DB user and password defined in catalog
- Add TaskListener to be Invoked
Select to call a Java application before/after the task runs to obtain information about the task. - Enable Auto Recover Task
Select if you want Server to automatically recover the task.- Maximum Retry Times
Specify the maximum number of times for retrying running the task to recover it. - Retry Interval
Specify the interval between retries. - Recreate All Results
Select if you want to recreate all results. By default, Server only recreates failed results.
- Maximum Retry Times
Conditions
Use the Conditions tab to specify the updating policy of the task. The tab contains two more tabs:
Time
Use the Time tab to specify the time for when you want to perform the task.
Time Zone
Select the time zone.
Time Type
Specify when you want to perform the task.
- Run this task immediately
Select if you want to perform the task as soon as you submit it. - Run this task at
Select if you want to perform the task at a specific time.- Date
Select the Calendar icon to select a date from the calendar. - Time
Specify the time of the day. - Run missed task upon server restart
Select if you want to perform missed tasks when you restart the server.
- Date
- Run this task periodically
Select if you want to perform the task on a repeated basis.- Do not generate cached result until a report requests
By default, Server generates the cached report data according to the specified time condition. Select this property if you want the task to perform only upon the first report running request based on the query after each scheduled time. - Duration
Specify the period during which you want to perform the task on a repeated basis.- Run after
Select and then specify the start date and time of the period. - Run until
Select and then specify the end date and time of the period.
- Run after
- Date
Specify the dates when you want to perform the task.- Daily
Select if you want to perform the task per a specific number of days or every weekday (from Monday to Friday). - Weekly
Select if you want to perform the task on the specific days of the week per a specific number of weeks. - Monthly
Select if you want to perform the task on a specific day of the month or week, per a specific number of months. - Show/Hide Exception
Select to show or hide the exception date box, which lists the dates when you do not want to perform the task.- Add
Select to add an exception date via the Select Condition dialog box. - Remove
Select to remove the selected exception dates.
- Add
- Daily
- Time
Specify the exact time of the day when you want to perform the task.- At
Select if you want to perform the task at a specific time of the day. - Hourly
Select if you want to perform the task at a specific minute per a specific number of hours. - Minutely
Select if you want to perform the task per a specific number of minutes.
- At
- Run missed task upon server restart
Select if you want to run missed tasks when you restart the server.
- Do not generate cached result until a report requests
Expires
Specify when you want the cached data to expire.
- Never
Select if you don't want the cached data to expire. - At
Select if you want the cached data to expire at a specific date and time. - After
Select if you want the cached data to expire after a period.
Trigger
Use the Trigger tab to set settings for specifying a trigger for the task.
Select a trigger to bind
Select a trigger from the list for the task.
New Trigger
Select to open the New Trigger dialog box to create a new trigger.
Logic with time condition
Specify the logic between the time condition and trigger condition.
- Trigger Only
Select if you want to perform the task only when an administrator fires the trigger. - Trigger and Time Condition
Select if you want to perform the task when both time is up and an administrator fires the trigger.When you select this logic:
- No matter which condition is ready, Server performs the task only when its counterpart is ready.
- If you specify to perform the task at a specific time, you must select Run missed task upon server restart, otherwise Server regards the task as expired and deletes it when the time condition is ready before the trigger condition.
- Time Condition after Trigger
Select if you want to perform the task when time is up after an administrator fires the trigger. If the time condition is ready before the trigger condition, Server regards the task as expired and deletes it. - Time Condition or Trigger
Select if you want to perform the task when either time is up or an administrator fires the trigger.
Notification
Use the Notification tab to notify someone by email when the task finishes running, regardless of whether it is successful or not.
When task is successful
Select if you want to send an email when the task performs successfully.
When task fails
Select if you want to send an email when the task fails.
To
Specify the address you want to send the email to.
Cc
Specify the address you want to copy the email to.
Bcc
Specify the address you want to secretly copy the email to.
Subject
Specify the subject of the email.
Comments
Specify the contents of the mail or comments to the contents.