Friday, January 23, 2015
How to check verbose SQL Server Agent Logging
Sometimes, the sql agent history does not provide enough information for debugging purpose. There is a way to see verbose logging information for each step:
go to a specific job step and click edit and go to Advanced tab
you can see Log to table or output file.. Click View and you can see much detailed log information
url: http://www.mssqltips.com/sqlservertip/1411/verbose-sql-server-agent-logging/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment