SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Chapter Essentials

Standardize, Automate, and Update The SAU methodology provides a logical thinking structure for the implementation of any new technology. It begins with standardization of configurations and operational procedures. Next, you automate as much of the management and maintenance of the technology as possible. Finally, you plan and implement update procedures so that the durability of the technology is acceptable.

Understanding SQL Server Jobs SQL Server jobs consist of one or more steps, schedules, alerts, and notifications. Jobs can be used to automate administrative and maintenance tasks. Standardization of generic job parameters, such as the job name, owner, and description, is very important.

Creating T-SQL Jobs T-SQL job steps ...