Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

New Features in version 2.2.1

IDERA Dashboard

  • SQL Enterprise Job Manager is now integrated with IDERA Dashboard 4.6.

Support

  • SQL Enterprise Job Manager now supports Microsoft Windows 2019 and SQL Server 2019 All Editions (Express, Standard, Enterprise, Datacenter, etc.)

Fixed Issues in version 2.2.1

Alerts

Status
colourGreen
titleSQLENTE-4885
 Alert subscriptions are now set properly in the Alert Rules.

Jobs

Status
colourGreen
titleSQLENTE-4892
 SQL Query´s are now working properly in SSMS when generating job schedules.

Job History

Status
colourGreen
titleSQLENTE-4891
 The Job History tab is now refreshing all operations properly.

Schedule

Status
colourGreen
titleSQLENTE-4811
 Job and Task filters are now working properly in the Schedule tab.

Upgrades

Status
colourGreen
titleSQLENTE-4904
 Upgrades from SQL EJM 2.1 to 2.2.1 are now working as expected.

New Features in version 2.2

IDERA Dashboard

  • SQL Enterprise Job Manager is now integrated with IDERA Dashboard 4.2.0.29.

Overview

  • The Home page is renamed to Overview. It is redesigned to allow users to obtain a quick status view of their environment related to scheduled jobs, tasks, and job chains across their enterprise.

Schedule

  • It is redesigned to allow users to get detailed information about their instances, jobs, tasks, and job chains across their environments.

Support

  • SQL Enterprise Job Manager now supports SQL Server 2016 and SQL Server 2017.

Fixed Issues in version 2.2

Email Alerts

Status
colourGreen
titleSQLENTE-4736
 The SMTP email alerts are sent successfully when one or more subscribers do not have an email address configured.

Status
colourGreen
titleSQLENTE-4656
  The "Refresh" link on the Instances, Jobs, and Dashboard page is working properly now.

  Instances 

Status
colourGreen
titleSQLENTE-4480
 A ZK error message is no longer displaying on the Add/Remove Instances window while Adding a Job in the homepage.

Jobs

Status
colourGreen
titleSQLENTE-4603
 Users can now add jobs to a custom category with special characters.

Status
colourGreen
titleSQLENTE-4600
 Users can now add or edit a job with a description with special characters.

Status
colourGreen
titleSQLENTE-4841
 Users can now edit jobs created with multiple instances.

Job and Schedule History

Status
colourGreen
titleSQLENTE-4764
  The Maximum Run Time and Average Run Time displayed on the Job History is now displaying the time values in hours/minutes/seconds.

Job Chaining

Status
colourGreen
titleSQLENTE-4749
 The Job Chains are now running properly.

Repositories

Status
colourGreen
titleSQLENTE-4651
 Same repositories names are validated now in the installation wizard.

Schedule

Status
colourGreen
titleSQLENTE-4542
 The Author/login account used to schedule a task is no longer changing to System name/Administrator when running the task.

Start Menu

Status
colourGreen
titleSQLENTE-4776
 Users have now a "SQL Enterprise Job Manager Help" shortcut in the Start Menu.

New Features in version 2.1

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.

...

  • When users drag and drop a job over a time slot with other scheduled jobs, the schedule is created accurately. 

  • Jobs that are dragged and dropped to a time slot where they are already scheduled are no longer duplicated. 

  • SQL Enterprise Job Manager accurately updates schedules for jobs created between 11:45 and 11:59 p.m. that are dragged and dropped to different time slots. 

  • Users scheduling jobs at 12:00 pm can now see the accurate time displayed in the Schedule tab of the Job Wizard.

  • Users accessing a specific day from the Month view in the Schedule tab can now see the correct date filter in the respective Day view.

  • SQL Enterprise Job Manager now displays a warning dialog when users drag and drop jobs in the Schedule tab.

  • When double-clicking a time slot in the Schedule tab to create a new job, SQL Enterprise Job Manager now displays the selected time in the Job Wizard.

...

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

...

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

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

...