How to send an email alert if the update process to a database fails?

• donnelcyril

  SSC Veteran

  Points: 215

  More actions

  January 27, 2009 at 1:32 pm

  #125952

  Hi,

  Is there any means by which we can identify whether an update has been made to a database.

  This is what I am trying to achieve:

  We are having a reporting server which is updated from the live database every night. At times this update functionality seems to crash especially after a restart from a power outage. If there was some table in the set of system tables that we can query into to check whether an update has been made , I can create an application that will run this query every morning and if it returns a null recordset ,send an email to alert the people concerned.

  Please let me know if this is possible or is there a better way for doing this.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  January 27, 2009 at 2:18 pm

  #933496

  What are you using to load the database? SSIS and an SQL Agent job? Something else?

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  January 27, 2009 at 2:20 pm

  #933497

  How are you doing the update? Is it via SSIS, DTS, SQL Agent Job etc?

  If so, you should be able to use their logging features to do this. Otherwise we'll need a bit more information from you.

  -Luke.

  To help us help you read this[/url]For better help with performance problems please read this[/url]