SQL Server Agent Properties (General Page)

Use this page to view and modify the general properties of the Microsoft SQL Server Agent service.

Options

Service state
Displays the current state of the SQL Server Agent service.

Auto restart SQL Server if it stops unexpectedly
SQL Server Agent restarts SQL Server if SQL Server stops unexpectedly.

Auto restart SQL Server Agent if it stops unexpectedly
SQL Server restarts SQL Server Agent if SQL Server Agent stops unexpectedly.

Filename
Specify the file name for the error log.

...
Browse to the error log file.

Include execution trace messages
Includes execution trace messages in the error log. Trace messages provide detailed information on SQL Server Agent operation. Therefore, the log file requires more disk space when this option is selected. This option should only be selected while troubleshooting a problem that may involve SQL Server Agent.

Write OEM file
Writes the error log file as a non-Unicode file. This reduces the amount of disk space consumed by the log file. However, messages that include Unicode data may be more difficult to read when this option is enabled.

Net send recipient
Type the name of an operator to receive net send notification of messages that SQL Server Agent writes to the log file.

See Also

Operators
SQL Server Agent Error Log