Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2011-07-27 : 22:05:46
|
| 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\SQLServerAgentErrorLoggingLevel =7 Questions1. 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. |
|
|
|
|
|
verbose logging for sql agent