Post reply

How to read from the SQL Agent Log.

  • March 14, 2012 at 6:23 am

    #258551

    Hi,

    We use - 'xp_readerrorlog' to read from the SQL Errorlog file.

    What is the query/command to read from the SQL Agent log file?

    -Regards

    Thanks.

  • March 14, 2012 at 6:27 am

    #1459115

    Here is a site that defines all the parameters for that extended procedure.

    exec xp_readerrorlog 1,2,null,null

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • March 14, 2012 at 6:28 am

    #1459116

    its the same, but you need to specify 0,2 where 0 is the log number and 2 means SQL Agent Log, so say you wanted the 10th rolled over log for the agent it would be

    xp_readerrorlog 10,2

  • March 14, 2012 at 7:03 am

    #1459146

    Thanks Guys...It works!

    Thanks.

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

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