Set Up the Job History Log

Applies to: yesSQL Server (all supported versions) YesAzure SQL Managed Instance

Important

On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details.

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

Before You Begin

Security

For detailed information, see Implement SQL Server Agent Security.

Using SQL Server Management Studio

To set up the 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:

    1. 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.

    2. Check Automatically remove agent history, and specify a time period, such that history older than this period will be purged from the log.

See Also

Implement Jobs
Monitor Job Activity
Create Jobs