Post reply

verbose logging

  • July 27, 2011 at 8:04 pm

    #240741

    Hi All,

    How to setup verbose logging for sql agent using T-sql.

    Am able to do it from registry and restarting the sql agent to get the registry changes to get into affect.

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MYSQL\SQLServerAgent

    ErrorLoggingLevel =7

    Questions

    1. Is there any direct query to set the verbose logging for sql agent rather making modifications to registry?

    2. Is there any T-sql using which we can get to know what is the current logging level set for SQL Agent?

    3. Once after making changes in registry do i need to restart the sql agent to changes get into affect?

    Thanks in advance.

  • July 28, 2011 at 6:24 am

    #1360008

    Don't use the registry. The setting is in the SQL Agent Properties.

    See this link: http://blogs.msdn.com/b/sqlagent/archive/2010/10/15/turning-on-verbose-logging-in-sql-agent.aspx

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • July 28, 2011 at 6:31 pm

    #1360515

    Thank you very much for the help.

  • July 29, 2011 at 5:05 am

    #1360665

    You're welcome. Let us know if you have any problems with the verbose logging.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • July 29, 2011 at 4:23 pm

    #1361161

    Sure 🙂

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

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