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:
- Check job settings and last run status across multiple SQL Server instances.
- View summary of key job statistics.
- Sort jobs by status or property, such as category, owner, or last run time.
- Bulk update job properties on multiple jobs across servers.
- Save job information.
How the Job Editor tool works
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.
Use the Job Editor tool
To use the Job Editor to view jobs:
- Open the IDERA SQL Admin Toolset Launchpad, and then click Job Editor.
- Specify the SQL Server instance or server group that contains the jobs you want to edit. To specify multiple SQL Servers, separate each instance name with a semicolon.
- Optional. Filter based on a timeframe by selecting the number of days, hours, and minutes in the Jobs not run in the last field.
- Click Get Job Information.
- View the results.
- If you want to save the results , copy the list to clipboard, or export the list as an XML or CSV file.
To use Job Editor to edit jobs:
- Get the job information from the target SQL Server instances.
- Select the jobs you want to edit. To select all jobs that match a specific search criteria, click Check Jobs by Property Values.
- Click Update Checked Jobs.
- On the Update Properties window, change the appropriate properties, and then click Update.