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

Understanding SQL Server Jobs

SQL Server jobs provide a primary tool for the automation of maintenance and data-related tasks. It is important that you understand the steps that a job can take and the properties used to configure jobs, all of which will be covered in this section. The last subsection will address common job types that you will create and standardize for your SQL Servers.

Job Steps

A SQL Server job is a collection of one or more steps. A step is a task or group of tasks that should be carried out by the job. The steps can be of any of the following types with a standard database engine implementation:

ActiveX Script Remember the Windows Scripting Host (WSH) introduced in Chapter 4, "SQL Server Command-Line Administration"? The ...