locked
sql server 2005 error RRS feed

  • Question

  • How can I check the reasons for Delivery failures by Notification Services? (I have looked everywhere I can think of without much luck.)
    Does anyone know where I can get a simple example to figure out how this service works ????

    I have been trying an example in Step by Step Books and everything seemed fine until I ran it.  I can see all the data that should be in the in various tables, so everything looks fine on the face of it.  But when I look at example, it has created about 20-30 tables and about as many stored procedures which makes it very difficult to track down the problem, its way too complex for what should be a simple example (hint to the authors here...).  Anyway after looking through various views I found some evidence of delivery failure but no reason is given.  I would have thought there would be log somewhere to indicate what went wrong but I cannot find it.    See info below:

    1 FileChannel PGDESKTOP 29/06/2009 16:42 29/06/2009 16:42 Delivery failed Birder1 Email en-us BN 21/02/1962 13:00 Fish Eagle on Crystal Beach
    2 FileChannel PGDESKTOP 29/06/2009 16:42 29/06/2009 16:42 Delivery failed Birder2 Email en-us BM 22/02/1962 11:01 Giant Heron at Birdinia Marshes
    3 FileChannel PGDESKTOP 29/06/2009 16:42 29/06/2009 16:42 Delivery failed Birder3 Email en-us BSC 21/02/1962 02:00 Night Owl at Pine Valley, mating calls
    4 FileChannel PGDESKTOP 29/06/2009 16:42 29/06/2009 16:42 Delivery failed Birder2 Phone en-us BM 22/02/1962 11:01 Giant Heron at Birdinia Marshes
    5 FileChannel PGDESKTOP 29/06/2009 16:43 29/06/2009 16:43 Delivery failed Birder1 Email en-us BN 21/02/1962 13:00 Fish Eagle on Crystal Beach
    6 FileChannel PGDESKTOP 29/06/2009 16:43 29/06/2009 16:43 Delivery failed Birder2 Email en-us BM 22/02/1962 11:01 Giant Heron at Birdinia Marshes
    7 FileChannel PGDESKTOP 29/06/2009 16:43 29/06/2009 16:43 Delivery failed Birder3 Email en-us BSC 21/02/1962 02:00 Night Owl at Pine Valley, mating calls
    8 FileChannel PGDESKTOP 29/06/2009 16:43 29/06/2009 16:43 Delivery failed Birder2 Phone en-us BM 22/02/1962 11:01 Giant Heron at Birdinia Marshes
                           
    Monday, November 19, 2012 1:14 PM

Answers

  • Hi Furamikea,

    There are stored procedures and views you can try to use.  Not sure which one you looked at above, but you might try:

    http://msdn.microsoft.com/en-us/library/ms176062(SQL.90).aspx

    Per the remarks, you might find more granular info at in: NSNotificationClassNameNotificationDistribution


    Iric Wen

    TechNet Community Support

    • Marked as answer by Iric Wen Tuesday, November 27, 2012 9:15 AM
    Tuesday, November 20, 2012 8:01 AM