all groups > sql server (alternate) > may 2006 >
You're in the

sql server (alternate)

group:

Storing SQL Server Agent logs in a relational store



Storing SQL Server Agent logs in a relational store Thyagu
5/29/2006 4:43:33 AM
sql server (alternate): 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.
Re: Storing SQL Server Agent logs in a relational store Erland Sommarskog
5/29/2006 9:25:31 PM
Thyagu (tdelli@gmail.com) writes:
[quoted text, click to view]

xp_cmdshell + type?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
AddThis Social Bookmark Button