Failed Subscriptions

• Abs-225476

  Hall of Fame

  Points: 3483

  More actions

  August 26, 2009 at 5:49 am

  #385249

  Hi,

  I want to know which tables I need to look at failed subscriptions.

  We have a number subscriptions on our system which sometimes fail.

  I want to write a sql query which will extract the relevant data about the failed subscription and email to me.

  What is the best way of monitoring failed instances?

  Thanks

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 26, 2009 at 9:47 am

  #1044980

  The only thing I have found is that the Subscriptions table has a LastStatus column, that you can check for '%fail%'

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question