Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
How to check the schedule update rules and the schedules associated with those rules?
Solution:
The query below can be used to check which schedule is being used by the schedule update rules. This needs to be manually run on the Spotfire application database. Here is an example query for Microsoft SQL Server (modification needed for Oracle databases):
SELECT A.[NAME] Schedule_Name,C.NAME Rule_Name FROM [dbo].[JOB_SCHEDULES] A , [dbo].[RULES_SCHEDULES] B , [dbo].[ROUTING_RULES] C WHERE A.ID=B.SCHEDULE_ID AND B.ROUTING_RULE_ID=C.ID
Disclaimer: The content of this article is for informational purposes only. The subject material may change in any new versions with no notice and there is no responsibility by TIBCO to maintain or support future access to this internal application content. Modification of any internal application content is not recommended and can lead to an unsupported configuration. It is not intended to be used "As Is" in a Production environment. Always test in a Development environment. Doc: Scheduled updates to analyses
Comments
0 comments
Article is closed for comments.