Products | Versions |
---|---|
TIBCO Data Virtualization | All Supported Versions |
1. Create a trigger in TDV Studio.
2. Enable it by checking the box 'Enable Trigger'.
3. Set the condition type to Timer Event
4. Select the Periodic option and Refresh every 1 day
5. Also, set the Start on date and time accordingly
6. Additionally, if the trigger needs to be restricted to work only on specific days then the Recurrence Restriction can be configured as well.
7. In the bottom window, change the Action Type to 'Execute Procedure'.
8. The Procedure Path needs to be set to the internal procedure '/lib/resource/RefreshResourceCache'
9. Now, RefreshResourceCache contains two parameters that need to be entered for a successful execution i.e. Path and type.
a) path: The path of the resource.
b) type: The type of the resource. Valid values: TABLE, PROCEDURE or POLICY
10. These two parameters need to be provided in the field Parameter Values
11. Once all the above information has been configured, the trigger can be saved.
Screenshot of the trigger: