Ask a questionAsk a question
 

AnswerOdd Notification Requirement

  • Wednesday, August 12, 2009 11:28 PMTrevor Brooks Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hello,

    Scenario: SERVER1 sends out an event that it has gone down ("Server Down" event), the subscriber only wants to receive a notification if SERVER1 doesn't send out a "Server Up" event within a certain amount of time, we'll just say 5 minutes.

    How would you do this in SQL-NS?

    See my previous post if you're interested in seeing the direction I've been heading with this.

    I could really use some ideas.

    Regards,
    Trevor

Answers

  • Tuesday, August 18, 2009 3:30 AMNai-dong Jin - MSFTMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi,

    Notification Services stores subscriber and subscription data in SQL Server databases. Using the subscription management objects, part of the Notification Services API, you can create a custom subscription management application to manage subscriber and subscription data.

    From the requirement, I think one of the practices is to build a Windows Service, and check the event log every five minutes, if it doesn't find the Server Up event from SERVER1, just notify the subscribers.

    Thanks.
    Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.

All Replies

  • Tuesday, August 18, 2009 3:30 AMNai-dong Jin - MSFTMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi,

    Notification Services stores subscriber and subscription data in SQL Server databases. Using the subscription management objects, part of the Notification Services API, you can create a custom subscription management application to manage subscriber and subscription data.

    From the requirement, I think one of the practices is to build a Windows Service, and check the event log every five minutes, if it doesn't find the Server Up event from SERVER1, just notify the subscribers.

    Thanks.
    Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.