Storing SQL Server Agent logs in a relational store
This is a discussion on Storing SQL Server Agent logs in a relational store within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi, I want to store the SQL Server Agent logs into a table. I was able to read SQL ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 07:31 PM
| ||||
| ||||
 Storing SQL Server Agent logs in a relational store Hi, I want to store the SQL Server Agent logs into a table. I was able to read SQL server errorlogs using sp_readerrorlog and store the data into a table successfully.I want to do the same for SQL Agent logs. options? Thanks in advance Thyagu.      |
|
02-29-2008, 07:31 PM
| ||||
| ||||
| Re: Storing SQL Server Agent logs in a relational store Thyagu (tdelli@gmail.com) writes: > I want to store the SQL Server Agent logs into a table. I was able to > read SQL server errorlogs using sp_readerrorlog and store the data into > a table successfully.I want to do the same for SQL Agent logs. options? xp_cmdshell + type? -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
Linear Mode
