Chat now with support
Chat with Support

Toad for SQL Server 7.4 - Installation Guide

SQL Server Objects
Edit Permissions on Objects Databases Tables Create and Alter Views Indexes Programmability Create and Alter Synonyms Security Storage Create and Alter Sequences Table, Database and Server Triggers Management Agent

View Agent History

Use the History page to limit the size of the job history log and to clear the current log file for the agent.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To view agent history

  1. Select an object under the Agent node in the Object Explorer.

  2. Click .

  3. Select the History page.
  4. Complete the fields as necessary. Review the following for additional information:

    Current job history log size (in rows)

    Displays the current number of rows in the job history log. Click Clear Log to clear the job history log and reset the rows to 0.

    Limit size of job history log

    Select this checkbox to limit the size of the job history log so it does not take up too much space in the msdb table.

    Maximum job history log size (in rows)

    Enter the maximum number of rows to store in the job history log before overwriting rows.

    Maximum job history rows per job

    Enter the maximum number of rows to store for each job.

 

Related Topics

Set Agent Properties

Set Advanced Agent Properties

Set Up Alert Systems

Set Up Job Systems

Set Agent ConnectionsView Agent History

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating