Welcome Sign in
SQL Server Developer Center
Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Database Engine
Operations
Administration
 How to: Set Up the Job History Log ...
Community Content
In this section
Statistics Annotations (0)
Other versions are also available for the following:
SQL Server 2008 Books Online (December 2008)
How to: Set Up the Job History Log (SQL Server Management Studio)

This topic describes how to set up the Microsoft SQL Server Agent job history log.

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Right-click SQL Server Agent, and then click Properties.

  3. In the SQL Server Agent Properties dialog box, select the History page.

  4. Choose from the following options:

    • Check Limit size of job history log, and then type the maximum number of rows for the job history log, and the maximum number of rows per job.
    • Check Automatically remove agent history, and specify a time period, such that history older than this period will be purged from the log.
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker