We have an application uses SQL Server 2005's sqlagent job feature to
runs around 20 jobs which a frequency of every 1, 2, 5, or 10 minutes
depending on the job.

Every now and then one of these job runs will error however by the
time anyone notices the job run history information is cleared from
the MSDB job history tables.

Anyone know where I can set the size/retention for job history?

Thanks
-- Mark D Powell --

SQL Server 2000 - To access the SQL Server Agent Job History in Enterprise Manager, navigate to:
Root
SQL Server Instance
Management
SQL Server Agent
Right click on SQL Server Agent
Select the 'Properties' option
Select the 'Job System' tab
In SQL Server 2000, it is possible to permit automatic deletions based on the values for the 'Maximum job history log size (rows)' and 'Maximum job history rows per job'. If you do not want SQL Server to automatically delete the data, uncheck the 'Limit size of job history log' check box.
----------------------------------------------
SQL Server 2005 - To access the SQL Server Agent Job History in Management Studio, navigate to:
Root
SQL Server Instance
SQL Server Agent
Right click on SQL Server Agent
Select the 'Properties' option
Select the 'History' page




Mark D Powell wrote:

Need to increase Job History SQL Server 2005
25-Mar-10

We have an application uses SQL Server 2005's sqlagent job feature to
runs around 20 jobs which a frequency of every 1, 2, 5, or 10 minutes
depending on the job.

Every now and then one of these job runs will error however by the
time anyone notices the job run history information is cleared from
the MSDB job history tables.

Anyone know where I can set the size/retention for job history?

Thanks
-- Mark D Powell --

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Making Silverlight Emulate Synchronous Requests
http://www.eggheadcafe.com/tutorials...ht-emulat.aspx

On Mar 30, 2:30*pm, tarun kumar wrote:
Thank you. I have emailed this information to myself so when I get
back to work I can apply this. Naturally I think to look everywhere
but the right place.

-- Mark D Powell --

On Apr 2, 10:03*am, Mark D Powell <Mark.Powe... (AT) hp (DOT) com> wrote:
Update. I cannot believe I overlooked the history tab on the sqlagent
properties. It is working fine and naturally no errors had occurred
since I may not have enough history to look up the details. Thanks
again.

-- Mark D Powell --