Products | Versions |
---|---|
TIBCO Scribe Insight | 7.9.1 |
This particular integration is a chained DTS where the actual order of execution is:
assaf1.dts ->assaf2.dts->assaf3.dts->assaf4.dts->assaf5.dts.
The Execution Job Viewer does not take milliseconds into account when sorting the DTS executions. Since assaf1, 2, and 3 all have a start time of 11:49:24, the Viewer displays them randomly. Timestamps, including milliseconds, are stored in the Scribe Internal database and can be located using a SQL Query.
To check if the DTS executions were run in the correct order, open SQL Server Management Studio and run the following query:
USE SCRIBEINTERAL
GO
SELECT * FROM SCRIBE.EXECUTIONLOG where listenerid = [put your IP ID value. in our example IP ID is 7] order by starttime desc ;
GO
The output should be similar to:
Note that assaf1.dts was started at 11:49:24.416, followed by assaf2.dts, starting at 11:49:24.707, etc. These timestamps indicate that the DTS files are following the order specified by the chained DTS.