March 24, 2006 at 9:03 am
Using DTS, we perform intermittent FILE Drops onto our Source SQL Server 2000 database and this data is transactionally replicated to the subscriber.
Our I/T user group would like to be alerted/notified WHEN data from the FILE drops has completed replicating onto the Subscriber (via Transaction Replication / continuous).
Looking for a solution to provide our Users w/ the indicator that the Data has completed Replicating and is ready for their use.
-thx in advance
March 24, 2006 at 9:14 am
At a prior site I worked at, we had a similar task to perform. What we did, was to create a control table on both sides of the replication, having a flag......0 for replicating, and 1 for done, finished.....and add the is table to the replication schema....
We would set the flag to replicating, update the data, and then set the flag to complete again.......since the transactional replication replicates the data in the order it's updated, the flag was a good indicator on the users system.....
We also had a job that monitored this flag, and sent an email when replication started, and another when it was done, on the client side.....
It may not be the best solution, but it worked well for the two years I was there.....the only issue we had, was getting people to remember to update the flags before and after the data mods....
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply