Transfer Jobs Task Editor (Jobs Page)

Use the Jobs page of the Transfer Jobs Task Editor dialog box to specify properties for copying one or more SQL Server Agent jobs from one instance of SQL Server to another. For more information about the Transfer Jobs task, see Transfer Jobs Task.

Note

To access jobs on the source server, users must be a member of at least the SQLAgentUserRole fixed database role on the server. To successfully create jobs on the destination server, the user must be a member of the sysadmin fixed server role or one of the SQL Server Agent fixed database roles. For more information about SQL Server Agent fixed database roles and their permissions, see SQL Server Agent Fixed Database Roles.

Options

  • SourceConnection
    Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the source server.

  • DestinationConnection
    Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the destination server.

  • TransferAllJobs
    Select whether the task should copy all or only the specified SQL Server Agent jobs from the source to the destination server.

    This property has the options listed in the following table:

    Value

    Description

    True

    Copy all jobs.

    False

    Copy only the specified jobs.

  • JobsList
    Click the browse button (…) to select the jobs to copy. At least one job must be selected.

    Note

    Specify the SourceConnection before selecting jobs to copy.

    The JobsList option is unavailable when TransferAllJobs is set to True.

  • IfObjectExists
    Select how the task should handle jobs of the same name that already exist on the destination server.

    This property has the options listed in the following table:

    Value

    Description

    FailTask

    Task fails if jobs of the same name already exist on the destination server.

    Overwrite

    Task overwrites jobs of the same name on the destination server.

    Skip

    Task skips jobs of the same name that exist on the destination server.

  • EnableJobsAtDestination
    Select whether the jobs copied to the destination server should be enabled.

    This property has the options listed in the following table:

    Value

    Description

    True

    Enable jobs on destination server.

    False

    Disable jobs on destination server.

See Also

Reference

Transfer Jobs Task Editor (General Page)

Expressions Page

Concepts

Integration Services Error and Message Reference

Integration Services Tasks

SMO Connection Manager