The Job Mover tool helps you move or copy SQL Server jobs from one SQL Server instance or database to another, preserving the associated actions as well as the assigned user privileges. You can also rename jobs during the move or copy operation. The Job Mover tool helps you achieve a faster result than script-based solutions.
How the Job Mover works
By default, the Job Mover tool connects to the specified SQL Server instance using the credentials of your currently logged on Windows account, and then collects information about the SQL Server jobs. Depending on your selection, Job Mover than copies or moves the specified jobs. If you are moving a job from one instance to another, Job Mover deletes the original job from the source instance.
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.
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
- Open the IDERA SQL Admin Toolset Launchpad, and then click Job Mover.
- On the Welcome window, click Next.
- Select which action you want to perform, and then click Next.
- If you are copying or moving a job to another instance, select the source and target SQL Server instance, and then click Next.
- If you are copying a job to another database on the same instance, select the source SQL Server instance, and then click Next.
- Select which jobs you want to move, and then click Next.
- Indicate whether you want to keep the existing job schedule and native SQL Server alerts and notification settings, and then click Next.
- Configure options for the new job, including whether the jobs are enabled or disabled, and then click Next.
- Review the summary, and then click Finish.