非常简洁实用，我替楼主上传了。:lol
摘抄一段：
Job Maintenance
1. Avoid overlapping jobs on the same SQL
Server instance. Ideally, each job should
run separately at different times.
2. When creating jobs, be sure to include
error trapping, log job activity, and set up
alerts so you know instantly when a job
fails.
3. Create a special SQL Server login
account whose sole purpose is to run
jobs, and assign it to all jobs.
4. If your jobs include Transact-SQL
code, ensure that it is optimized to run
efficiently.
5. Periodically (daily, weekly, or monthly)
perform a database reorganization on all
the indexes on all the tables in all your
database. This will rebuild the indexes
so that the data is no longer logically
fragmented. Fragmented data can cause
SQL Server to perform unnecessary
data reads, slowing down SQL Server’s
performance. Reindexing tables will also
update column statistics.
6. Don’t reindex your tables when your
