September 2010
Intermediate to advanced
1704 pages
111h 8m
English
Figure 16.1 shows the SQL Server Agent Properties dialog that appears when you right-click and select Properties on the SQL Server Agent node located on the root of the Object Explorer tree.
Figure 16.1 SQL Server Agent properties.

You can set several different types of properties in the SQL Server Agent Properties dialog. The General options are displayed by default, and they include the capability to set the auto restart options and define an error log for the SQL Server Agent. Selecting the option Auto Restart SQL Server Agent If It Stops Unexpectedly is best for most installations. There is usually ...