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)