Select Jobs from msdb (optional)

Copy Database Wizard

Copy Database Wizard Help

Select Jobs from msdb (optional)

Use this screen to specify the jobs you want to include in the move or copy operation. This screen appears after you select User-selected jobs on the Select Related Objects screen.

Options

Source

Displays the source jobs available from the msdb database.

Type

In Microsoft® SQL Server™ 2000, jobs are the only object type that can be copied from the msdb database.

Destination

Displays the status of the source job on the destination server.

Select All

Click to select all the listed source jobs.

Clear All

Click to clear all the selected source jobs.

Jobs Copy Option

All jobs detected at package runtime

Use the option to copy all jobs detected at package runtime.

Selected jobs

Use this option to copy all the selected jobs.