How to check the schedule update rules and the schedules associated with those rules?
Article ID: KB0075789
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | 7.5 and higher |
Description
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.
Issue/Introduction
How to check the schedule update rules and the schedules associated with those rules?
Resolution
Here is an example query for Microsoft SQL Server (modification needed for Oracle databases):
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.
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.
Additional Information
Doc: Scheduled updates to analyses
Feedback
Yes
No
Powered by
