Page History

Versions Compared

Job overlap viewer

SQL Enterprise Job Manager now allows you to view and identify jobs running in the same time slot. By modifying settings on overlapping events, users can improve job execution and server resource use.

Maintenance mode for instances

Version 2.1 allows you to assign a Maintenance mode schedule during Instance registration. You can also choose to disable alerts and notifications during the Maintenance mode period.

Creating Jobs for multiple instances

SQL Enterprise Job Manager now allows you to create Jobs to be executed simultaneously on multiple instances in your environment.

Server Performance Timeline

Version 2.1 displays a graphical overview per server. You can view the jobs across all SQL Server instances on a specific server and the number of CPU cycles generated by this workload. Additionally, a job runtime chart displays the jobs that have been run in the server and their duration.

Saving filtering options

SQL Enterprise Job Manager now allows saving your preferred filtering options to apply them later as needed.

Monitor, edit, and create Windows Tasks on registered instances

Version 2.1 allows you to monitor and edit scheduled Windows tasks from registered instances, as well as to create new Windows tasks.
Filter options in the Job History Tab
Users are now able to filter jobs by Day/Week/Month in the Job History tab.
Owner and Location properties for Instance Alerts
Users can now configure Instance type alerts using owner and location properties.

Schedule Tab

...

Integration with the IDERA Dashboard

Version 2.0 allows you to register as many instances of your SQL Enterprise Job Manager with the IDERA Dashboard. The IDERA Dashboard provides a platform of services that allow an integrated user experience across multiple IDERA products.

Job Chaining

SQL Enterprise Job Manager now allows you to chain multiple jobs together with created dependencies so that when one job completes, another job is run. This new feature lets the user create and manage job chains for one server or accross multiple servers.

Job Trending

The new Job Trends option lets users get a graphical representation and the estimated trends for job runtimes and execution counts. Users can choose to see the trends for the most frequent jobs, top failures, longest running jobs, and highest percentage duration increase.

Instance Specific View

SQL Enterprise Job Manager now allows users to click any SQL Server instance and access its specific information such as alerts, upcoming jobs, and job history.

Job Specific View

Users can now click any Job and access its specific information such as alerts, upcoming runtimes, and job history.

SQL Enteprise Job Manager 1.1 Daylight Saving Time (DST) considerations

IDERA recommends that you upgrade your SQL Enterprise Job Manager to version 1.1 to avoid issues with DST changes.
SQL Enterprise Job Manager 1.0 will run your jobs properly (on the correct scheduled times) after DST (March 8th, 2015), but the Schedule tab may show your jobs scheduled offset by one hour.

When the server running SQL Enterprise Job Manager is rebooted, users will no longer find that the SQL Enterprise Job Manager Collection service has not started.

...