Looking for subscription expiration value

• Chrissthom

  SSChasing Mays

  Points: 656

  More actions

  January 31, 2006 at 5:33 pm

  #152720

  I am attempting to write a script that will look at the my merge subscriptions and determine if they are about to expire because they have not synced with the publisher before the retention period is up. The problem is I am having trouble determining what sys table values to key off.

  I know i can see the retention period with the <userDB>..sysmergepublication.retention value. Then I can jsut do an aggregate function off of the last sync date.

   However what I am not able to find is the value for the last time the subscription synced. There is a <userDB>..sysmergepublication.last_sync_date column, but I have checked this value in several of our merge replicated environments and all rows have null values. This cannot be right because at least half of the subscriptions are active continuous subs, so I know they have not expired.

  I spent a fruitless chunk of today trying to look through system cleanup stored procs, but they it seems that they all reference other sys stored procs which reference other sys stored procs and never name the sys table they are looking at. Very frustrating........

  So, i am wondering if anyone know where the last sync data is stored for merge subscriptions.

  Additionally, if you think I am going about this all wrong I am also open to your input.

  Thanks,

  Chris

• TriggerMe

  SSChampion

  Points: 11752

  More actions

  January 31, 2006 at 10:31 pm

  #618043

  Firstly, this thread should be in the Replication forum.

  Secondly, the Subscription expiration value is a property of the Distributor. Have you tried checking the SYstem Tables on the Distribution Database?

  ---

  Kindest Regards,