Writing alerts to errorlog and event log

• Schil

  Old Hand

  Points: 383

  More actions

  June 27, 2002 at 8:48 am

  #157862

  Hi all,

  I was wondering whether there is a faster/cleaner way to get messages in the Sql Server Error log and Win event log.

  Currently I have an alert defined (step 1). Upon occurence of the alert, a SqlAgent job is executed (step 2) which uses xp_logevent (step 3) to write to the errorlog and eventlog.

  Is there a other cleaner way to achieve the same (thus less steps), 'cause now I'll have to write a job per alert, which is kind of a pain in .... and not very mangeable..

  Any suggestions are greatly appreciated,

  kind regards,

  Marcel

  
  With Kind Regards/Met vriendelijke groet
  Schil
  'It's never ending and never surrendering' Unida 1999

• Klaas-Jan

  SSCrazy

  Points: 2297

  More actions

  June 27, 2002 at 9:09 am

  #431742

  Hi Marcel, if you want to write customized error messages to the eventlog you can select the always write to windows event log.

  The system messages severity higher then 19 are written to the eventlog.

  With sp_altermessage you can define which messages that are lower then 19 are also written to the eventlog.

  (in sql2k)

  regards,

  klaas-Jan

• Schil

  Old Hand

  Points: 383

  More actions

  June 27, 2002 at 9:47 am

  #431750

  Klaas-Jan,

  Thanks for your fast reply.

  I think your suggestion does not work for alerts of type 'SQL Server performance condition alert'. Is that true?

  For alerts of type 'SQL Server event alert' it certainly works: thanks again.

  Problem is I have a 'performance'type alert.

  Kind regards,

  Marcel

  
  With Kind Regards/Met vriendelijke groet
  Schil
  'It's never ending and never surrendering' Unida 1999