Post reply

How to Export error log (filter on specific errors) as a job

  • April 28, 2005 at 12:45 pm

    #166596

    Hi all,

    I want to export specific errors from the error log as a text file, and automate this as a job, as in:

    if there's Error: 523 or Error: 1011, etc, export those rows. Unfortunately there's no more syslogs table

    I know I can export the whole log manually (Right-click on log, export), but how can I do that in sql from a job?

    Thanks a bunch

     

  • April 28, 2005 at 12:51 pm

    #555662

    creaet a SP to use xp_readerrorlog to load the errorlog file into a table, filter it and export it.

  • April 28, 2005 at 2:44 pm

    #555703

    thanks allen

  • April 29, 2005 at 12:18 am

    #555772

    Try on code similar like this

    CREATE TABLE #errors

    (errorlog varchar(255), continuationrow int)

    INSERT #errors

    (errorlog, continuationrow)

    EXEC xp_readerrorlog

    SELECT errorlog

    FROM #errors WHERE errorlog LIKE '%Login failed%'

    DROP TABLE #errors

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • April 30, 2005 at 5:15 pm

    #556149

    You can also use the Log Parser exe file. It's free download from microsoft and it has so many usages. You can also use it for the event viewer logs and many other logs and other data format as well

Viewing 5 posts - 1 through 4 (of 4 total)

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