O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required