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.
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.
| | | | | | | |