September 4, 2009 at 5:48 am
Hi,
i have setup a new server , SQL server 2005 with SP2
i found that JOB log history is getting disappeared in 2-3 days , because of that
i couldnt get the information about the status of the jobs.
Can anybody tell me that what option i need to check/verify in SQL server agent
so that i can get the job history atleast for 1 month. ?
Thanks
Bhuvnesh
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 4, 2009 at 6:48 am
There is a setting where you define maximum no of rows of history of a particular job.
Pls go through this link:
http://www.mssqltips.com/tip.asp?tip=1269
September 4, 2009 at 6:51 am
Right click on SQL Server Agent node in the SQL Server Management Studio Object Explorer.
Select Properties -> History
Change the values according to your requirement.
September 7, 2009 at 7:06 am
You probably need to radically up the maximum entries and the maximum entries per job.. Depending on how often your jobs run you might need to set these rather high..
CEWII
September 7, 2009 at 7:32 am
you can use the frequency of the job to gauge how many entrys you will get and adjust the size based on that
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply