The Job Editor tool helps you easily manage your SQL Server jobs by performing bulk updates across your environment. For example, you can sort jobs by status and property, such as whether the job is enabled and who is the owner. You can then bulk update the owners to a new login. The Job Editor tool allows you to:
When you edit jobs that exist on different SQL Server instances, you can choose from the values currently available on the selected instances.
This restriction affects the general job properties, such as the job owner, and the notification settings. Be aware that SQL Server has dependencies between the notification types, levels, and operators. For example, you cannot change the notification level if an operator was not previously assigned to the job. For more information about managing notifications, see Microsoft SQL Server Books Online.
By default, Job Editor connects to the specified SQL Server instances using the credentials of your currently logged on Windows account, and then collects job statistics for all jobs deployed on these instances.