verbose logging

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  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.

• Brandie Tarvin

  SSC Guru

  Points: 173105

  More actions

  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.

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  July 28, 2011 at 6:31 pm

  #1360515

  Thank you very much for the help.

• Brandie Tarvin

  SSC Guru

  Points: 173105

  More actions

  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.

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  July 29, 2011 at 4:23 pm

  #1361161

  Sure