The following excerpt, courtesy of McGraw-Hill Osborne Media, is from
Chapter 5 of the book "SQL Server 2000 for experienced DBAs" written by Brian Knight. Click for the complete book excerpt series or purchase the book.
Setting Job Notifications
You can have SQL Server notify you when a job completes. This is certainly a
better alternative than going through the work involved in checking the system to
see if a given job actually did run. This is one way to make system maintenance
a bit easier.
Configure job notifications in the Job Properties dialog box under the
Notifications tab (see Figure 5-11). You can specify notification methods and
the conditions under which notifications are sent. Use the Write To Windows
Application Event Log option to force a log entry when the job fails, succeeds,
or completes. The Automatically Delete Job option is handy when you need to
run a job to rebuild an index late at night during off-peak hours. The job runs
and automatically cleans itself up.
Figure 5-11 Select the conditions for job notifications
Click for the next excerpt in this series: Forecasting Growth
Click for the
complete book excerpt series.
