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.
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.
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.