locked
Are Notification Services right for this? RRS feed

  • Question

  • I have a process which logs machine data to the database each hour.  I need to sent managers a notification when an insert fails.  The insert can fail if the machine is offline, in that case the process does not even try to log anything; OR when the machine counts are returned as invalid data in which we have an insert attempt, however it fails due to NULL constraints.

    Would Notification services be able to execute hourly then provide a notification to subscribers if the query returns zero rows?

    Monday, July 7, 2008 5:15 PM

Answers

  • Sub-day scheduling isn't possible with SSNS. So to implement this, you'd need to create multiple scheduled subscriptions, one for each hour of the day.

    Although you could certainly use SSNS for this application, you could also use other means to accomplish the same thing. Perhaps a scheduled job and database mail?

    HTH...

    Joe

    Monday, July 14, 2008 12:42 PM

All replies

  • It should be no problem. With the advent of SQL Server 2005, your application can request SQL Server to notify it when critical data in a database has changed. 

     

    Here is a page with introdcution and code that you may reference:

    Using and Monitoring SQL 2005 Query Notification: http://www.simple-talk.com/sql/sql-server-2005/using-and-monitoring-sql-2005-query-notification/

     

    Hope this helps.

    Dannol

    Tuesday, July 8, 2008 3:10 AM
  • Sub-day scheduling isn't possible with SSNS. So to implement this, you'd need to create multiple scheduled subscriptions, one for each hour of the day.

    Although you could certainly use SSNS for this application, you could also use other means to accomplish the same thing. Perhaps a scheduled job and database mail?

    HTH...

    Joe

    Monday, July 14, 2008 12:42 PM