book
Article ID: KB0075789
calendar_today
Updated On:
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.
Resolution
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.
Issue/Introduction
How to check the schedule update rules and the schedules associated with those rules?