Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to put the Windows SQL DB Agent in debug?

DB Agent Tips

How to put the Windows SQL DB Agent in debug?

by  davidmichel  Posted    (Edited  )
SQL Agent in Debug

BAB 9.0/11.0
HKEY_LOCAL_MACHINE\SOFTWARE\ComputerAssociates\BrightStor ARCserve Backup\DSAgent\CurrentVersion\agent\dbasql

BEB 10.5
HKEY_LOCAL_MACHINE\SOFTWARE\ComputerAssociates\BrightStor Enterprise Backup\DSAgent\CurrentVersion\agent\dbasql

BEB 10.0
HKEY_LOCAL_MACHINE\SOFTWARE\ComputerAssociates\Cheetah\DSAgent\CurrentVersion\agent\dbasql

ASNT 6.6 / 7.0
HKEY_LOCAL_MACHINE\SOFTWARE\ComputerAssociates\ARCservIT\DSAgent\CurrentVersion\agent\dbasql

ASNT 6.0 / 6.5
HKEY_LOCAL_MACHINE\SOFTWARE\Cheyenne\DSAgent\CurrentVersion\agent \dbasql

With Parameters double click on the value Debug.
The DWORD editor will popup, change Data: 0 to 1.

Other acceptable data values = 2, 3, 4 (higher value generating the most detail in the log)

Result: in the Agent directory you will find:

dbasql.log
dbasql.trc
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top