Page History
...
By default, the Job Mover tool connects 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.
| 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
...
- Open the IDERA SQL Admin Toolset Launchpad, and then click click Job Mover.
- On the Welcome window, click click Next.
- Select which action you want to perform, and then click click Next.
- If you are copying or moving a job to another instance, select the source and target SQL Server instance, and then click click Next.
- If you are copying a job to another database on the same instance, select the source SQL Server instance, and then click click Next.
- Select which jobs you want to move, and then click click Next.
- Indicate whether you want to keep the existing job schedule and native SQL Server alerts and notification settings, and then click click Next.
- Configure options for the new job, including whether the jobs are enabled or disabled, and then click click Next.
- Review the summary, and then click Finish.
IDERA SQL Admin Toolset delivers 24 essential administration tools. Learn more > >
...
- click Finish.
...