7.0
/
When updating a large volume of data, you often need to repeatedly schedule the data update at a fixed time to ensure that the latest database data can be displayed.
You will be notified of the dataset update result after the update, including failure reasons (if any), to verify whether your data was updated successfully.
FineBI supports the scheduled update function. With the preset time, you can schedule your update more reasonably.
The scheduled update function supports global scheduled update, folder scheduled update, and single table scheduled update.
Besides, the scheduled update function also supports Result Notice so that you can stay promptly informed of the update results.
Before performing a data update, you need to log in as an admin, or you need to have management permission for the data you intend to update.
You are not advised to set an excessively high update frequency. If the update frequency is set too high, the system may start the next update before the current one is completed, increasing the risk of a system crash.
Only the super admin can configure global updates.
1. Go to Data Directory, click the icon, and click the Global Update button, as shown in the following figure.
2. Click Schedule Setting, as shown in the following figure.
1. The scheduled update setting page will appear after you click Schedule Setting. On this page, you can configure specific settings for your scheduled update.
Task Name: You can rename the scheduled update task.
Start Time and End Time: The two setting items refer to the start time and end time of your update task, respectively, not the duration. The granularity of the start and end time can be precise to hours, minutes, and seconds. You can click to select the start time.
Execution Frequency: Four options are available, including Only Execute Once, Execute Repeatedly, Set Detailed Frequency, and Set Expression.
Result Notice: After enabling the function, you can set Notification Time, Notification Recipient, and Notification Method.
The following figure shows the example of the setting.
The setting items of Execution Frequency and their corresponding End Time are as follows.
Only Execute Once
The scheduled update task is executed only once after the set start time.
There is no need to set the end time.
Execute Repeatedly
Four types of time granularity can be set: Minute(s), Hour(s), Day(s), and Week(s). Simple interval time setting is available. For example, Every 1 Day(s) Execute Once can be set.
Three options for the end time are available if Execute Repeatedly is selected.
Unlimited: With no end time, your scheduled update task will continue to be executed as scheduled.
Set End Time: The setting method for the end time is consistent with that of the start time. Once the end time you have set is reached, your scheduled update task will no longer be executed.
Extra Repeated Execution Times: Once your scheduled update task is executed at the start time you have set, the task will be executed extra times after the interval time is reached. The execution times can be set manually.
Set Detailed Frequency
You can configure a refined interval.
Execution Time: The execution time can be specified in minutes. You need to enter an integer between 0 and 23 for hours and an integer between 0 and 59 for minutes.
Execution Day: Every Day, Every Week, and Every Month can be selected. Single or multiple selections can be made between Monday and Sunday in Every Week. Single or multiple selections can be made between the 1st and the 31st in Every Month.
Execution Month: Single or multiple selections can be made between January and December in a year.
Two options for the end time are available if Set Detailed Frequency is selected.
Set Expression
The update frequency for a specific time can be set.
Five preset expressions are included in the system.
You can also enter a custom expression to set the update frequency.
You can enter a Cron expression for the time frequency. A valid expression is required for the scheduled update to work.
Two options for the end time are available if Set Expression is selected: Unlimited or Set End Time. For details, you can refer to the setting for Set Detailed Frequency.
Note: For details about the usage of the Cron expression, see the "Cron Expression" section.
The following are the options for the notification content.
Notification Time
The checkbox for Notify Only When Task Error Occurs can be ticked. If it is ticked, you will be noticed only when there are some update failures.
Notification Recipient
You can set Dept., Role, or User in Notification Recipient.
Note: You will receive the notification as long as you are included in any selected department, role, or user list.
Notification Method
You can select Platform Notification, Email Notification, or SMS Notification.
Note: Email Notification and SMS Notification need to be configured in System Management. For details, see Mailbox.
2. Click OK. Then, you can see your scheduled update tasks in the update task box. Besides, multiple scheduled tasks can be created, edited, and deleted, as shown in the following figure.
According to the settings in the example, Anna from the technical support department can log in to the FineBI system, click the icon in the upper-right corner, and click View Message. In this way, Anna can see update task execution result details, as shown in the following figure.
1. Go to Data Directory, select the folder you want to update, click Folder Update, and click Schedule Setting, as shown in the following figure.
2. After you click Schedule Setting, the Scheduled Update setting page will appear. The setting method and page for the folder scheduled update are consistent with those of Global Scheduled Update. (For details, see the "Global Scheduled Update" section.) Set Notification Recipient to Sales department and Notification Method to Platform Notification, as shown in the following figure.
3. Click OK. In this way, a folder scheduled update task is successfully configured.
1. Select the dataset you want to update, choose Update Information > Single Table Update, as shown in the following figure.
3. After you click Schedule Setting, the Scheduled Update setting page will appear. The setting method and page for the single-table scheduled update are consistent with those of the global scheduled update, but Single Table Update supports two update methods: Full-Volume Update and Incremental Update, as shown in the following figure.
Once you have configured Incremental Update, you can select the update method for the incremental update. For details, see Incremental Update Overview.
For details, see Cron Expression Example.
For details, see Update Restriction and Prompt.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy