Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Before using Job Mover, it is important that you understand that Job Mover requires your Windows user account to have administrative access to the target SQL Server instance. Job Mover uses administrative shares to perform the job copy.

Note

Please note that as part of the Copy/Move Jobs action, Run As is not copied. You must manually update Run As.

Use the Job Mover tool

To move jobs using Job Mover

...

  1. Open the IDERA SQL Admin Toolset Launchpad, and then click Job Mover.
  2. On the Welcome window, click Next.
  3. Select which action you want to perform, and then click Next.
  4. If you are copying or moving a job to another instance, select the source and target SQL Server instance, and then click Next.
  5. If you are copying a job to another database on the same instance, select the source SQL Server instance, and then click Next.
  6. Select which jobs you want to move, and then click Next.
  7. Indicate whether you want to keep the existing job schedule and native SQL Server alerts and notification settings, and then click Next.
  8. Configure options for the new job, including whether the jobs are enabled or disabled, and then click Next.
  9. Review the summary, and then click Finish.

...