Post reply

Writing alerts to errorlog and event log

  • 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

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply