SQL Server Agent Properties (Advanced Tab)

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

SQL Server Agent Properties (Advanced Tab)

Use this tab to view or specify the following options.

Options

Auto restart SQL Server if it stops unexpectedly

Automatically restart the Microsoft® SQL Server™ service if it terminates unexpectedly.

Auto restart SQL Server Agent if it stops unexpectedly

Automatically restart the SQL Server Agent service if it terminates unexpectedly.

Forward events to a different server

Forward new SQL Server events in the Microsoft® Windows® application log to the specified server.

Server
Specify the server to which to forward events.
Unhandled events
Forward only events that have not been handled locally.
All events
Forward all events, even those that have been handled locally.

If error has severity of or above

Specify the severity level for forwarding events to the selected server. The value is greater than or equal to the selected severity level.

Average CPU usage falls below

Specify the idle CPU condition by percentage. Idle is when the average CPU usage remains below the selected percent for the specified number of seconds.

And remains below this level for

Specify the idle CPU condition by seconds. Idle is when the average CPU usage remains below the selected percentage for the specified number of seconds.

See Also

How to autostart SQL Server Agent (Enterprise Manager)

How to designate an events forwarding server (Enterprise Manager)

How to set CPU idle time and duration (Enterprise Manager)