Jobs are for the automated processing you wish to perform. With this version of SQL Server, this has been significantly enhanced. Each job can contain multiple steps which are discrete units of processing. Each of these steps can have success and failure dependencies that allow you to redirect the flow of a job. Finally, multiple schedules can be created for each of the jobs.

Creating a Job

The steps to creating a job are as follows:

1. Right click the Jobs item and select New Job as shown in Figure 13.7.
2. Specify a job name, category, owner, and description
3. Add job steps
4. Create a schedule
5. Specify any notifications

Creating a new job.

This job was created with a category of Data Loads. This is a custom category that was added by right clicking on the Jobs item and selecting All Tasks | Manage Job Categories item. You should be as descriptive as possible with the name as well as the optional description for documentation purposes. You should also create your own job categories to add in grouping each of your jobs together.

SQL Server Agent 1 2 3 4 5 6 7 8 9