Target table column with systimestamp datatype displays that data was applied 1 second later than specified in the "stop post at sourcetime" command.
Example:
On Target the following post command was issued:
sp_ctrl> stop post at sourcetime HH:MM:SS ----> Example 12:00:00
sp_ctrl> stop post at sourcetime 12:00:00
The target table column with datatype "systimestamp" shows that data posted 1 second later ----> example 12:00:01
In other words, select from the target table shows that the data was posted one second later than specified in the "stop post at sourcetime" command.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center