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

Agent

Edit Agent Properties

Define Agent Properties

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

To define agent properties

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

  2. Click .

  3. Complete the fields as necessary.  Review the following for additional information:

    Service Startup Account

    Description

    Service state

    Displays the current state of the SQL Server agent.

    Startup type

    Displays whether this agent starts automatically or manually.

    Startup account

    Select whether to use the system account or an alternate account and password to startup the agent.

    Auto Restart Services

    Description

    Auto restart SQL Server if it stops unexpectedly

    Select this checkbox to automatically restart the SQL Server if it stops unexpectedly.

    Auto restart SQL Server Agent if it stops unexpectedly

    Select this checkbox to automatically restart the SQL Server Agent if it stops unexpectedly.

    Error Log

    Description

    File name

    Enter or browse to the location of the error log file. To view the error log, click View.

    Include execution trace messages

    Select this checkbox to include trace messages in the log file.

    Caution: This option can result in a very large log file. You should only select this checkbox when investigating a specific SQL Server Agent problem.

    Write OEM file

    Select this checkbox to write errors from the client OEM.

    Net send recipient

    Enter the network name of the user to send a network message. Click Test to verify that this option is working.

 

Related Topics

Set Advanced Agent Properties

Set Up Alert Systems

Set Up Job Systems

Set Agent Connections

View Agent History

 

View Agent Error Logs

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

To view an agent error log

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

  2. Click .

  3. Select the General page.
  4. Click View in the Error Log pane.

  5. Complete the fields as necessary. Review the following for additional information:

    Type

    Select the type of error you want to view.

    Containing text

    Enter a partial or full word/number that is contained in the error message.

 

Related Topics

Set Agent Properties

Set Advanced Agent Properties

Set Up Alert Systems

Set Up Job Systems

Set Agent Connections

View Agent History

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating