New Features in version 2.3
There are no new features in version 2.3
Fixed Issues in version 2.3
Alerts
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4900 |
|---|
|
SQL Enterprise Job Manager now offers the "Always Send Email" option in the Configure Alert Email Settings. This option allows SQL EJM to send email alerts for all job-related alerts.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4911 |
|---|
|
SQL Enterprise Job Manager now allows to Submit on the Alert Wizard for the Job Wizard.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4914 |
|---|
|
SQL Enterprise Job Manager added the ability to configure the location type in the alert rules wizard. Dashboard
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4922 |
|---|
|
SQL Enterprise Job Manager web console successfully adds instances in the ''FIPS compliant environments'' dashboard.
Database
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4775 |
|---|
|
The SQL Enterprise Job Manager repository database is now properly purged when deleting an instance.
Jobs
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4788 |
|---|
|
SQL Enterprise Job Manager 2.3 supports a new option for root job lists.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4869 |
|---|
|
In the SQL Enterprise Job Manager 2.3 Job Wizard, the operator view settings is successfully configured.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4917 |
|---|
|
SQL Enterprise Job Manager database configuration remains configured when editing a job.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4920 |
|---|
|
Secondary jobs run successfully when Enterprise Job ManagerJobChain includes root jobs from different instances.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4924 |
|---|
|
Job Chain schedule issues have been fixed, meaning that Job Chain is correctly scheduled, updated, and configured. Schedule
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4814 |
|---|
|
Now, it is possible to reconfigure the job's schedule by the drag and drop feature in the Schedule Tab. Other Issues
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4497 |
|---|
|
The Server Performance Chart correctly shows CPU information.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4809 |
|---|
|
It is now possible to apply Product Administrator permission to a user group.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4857 |
|---|
|
The links in the side panel of the overview tab now correctly redirect to the disabled Jobs, disabled Job Chans, and Failed Tasks.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4899 |
|---|
|
SQL Enterprise Job Manager now supports .NET 4.8 and below.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4905 |
|---|
|
SQL Enterprise Job Manager installation is successful when enabling FIPS.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 |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4885 |
|---|
|
Alert subscriptions are now set properly in the Alert Rules. Jobs
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4892 |
|---|
|
SQL Query´s are now working properly in SSMS when generating job schedules. Job History
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4891 |
|---|
|
The Job History tab is now refreshing all operations properly. Schedule
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-4811 |
|---|
|
Job and Task filters are now working properly in the Schedule tab. Upgrades
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLENTE-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 |
|---|
| colour | Green |
|---|
| title | SQLENTE-4736 |
|---|
|
The SMTP email alerts are sent successfully when one or more subscribers do not have an email address configured.| Status |
|---|
| colour | Green |
|---|
| title | SQLENTE-4656 |
|---|
|
The "Refresh" link on the Instances, Jobs, and Dashboard page is working properly now. Instances
| Status |
|---|
| colour | Green |
|---|
| title | SQLENTE-4480 |
|---|
|
A ZK error message is no longer displaying on the Add/Remove Instances window while Adding a Job in the homepage. Jobs
| Status |
|---|
| colour | Green |
|---|
| title | SQLENTE-4603 |
|---|
|
Users can now add jobs to a custom category with special characters.| Status |
|---|
| colour | Green |
|---|
| title | SQLENTE-4600 |
|---|
|
Users can now add or edit a job with a description with special characters.| Status |
|---|
| colour | Green |
|---|
| title | SQLENTE-4841 |
|---|
|
Users can now edit jobs created with multiple instances. Job and Schedule History
| Status |
|---|
| colour | Green |
|---|
| title | SQLENTE-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 |
|---|
| colour | Green |
|---|
| title | SQLENTE-4749 |
|---|
|
The Job Chains are now running properly. Repositories
| Status |
|---|
| colour | Green |
|---|
| title | SQLENTE-4651 |
|---|
|
Same repositories names are validated now in the installation wizard. Schedule
| Status |
|---|
| colour | Green |
|---|
| title | SQLENTE-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 |
|---|
| colour | Green |
|---|
| title | SQLENTE-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.
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.
Fixed Issues in 2.1
Schedule Tab
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 to edit credentials on a single instance in the Manage SQL Server Instances section of the Administration tab.
Services names are displaying correctly in the warning message that prompts when services are stopped.
New Features in version 2.0
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.
Fixed issues in 2.0
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.
| Scroll pdf ignore |
|---|
| Newtabfooter |
|---|
| alias | IDERA |
|---|
| url | http://www.idera.com |
|---|
|
| | Newtabfooter |
|---|
| alias | Products |
|---|
| url | https://www.idera.com/productssolutions/sqlserver |
|---|
|
| | Newtabfooter |
|---|
| alias | Purchase |
|---|
| url | https://www.idera.com/buynow/onlinestore |
|---|
|
| | Newtabfooter |
|---|
| alias | Support |
|---|
| url | https://idera.secure.force.com/ |
|---|
|
| | Newtabfooter |
|---|
| alias | Community |
|---|
| url | http://community.idera.com |
|---|
|
| | Newtabfooter |
|---|
| alias | Resources |
|---|
| url | http://www.idera.com/resourcecentral |
|---|
|
| | Newtabfooter |
|---|
| alias | About Us |
|---|
| url | http://www.idera.com/about/aboutus |
|---|
|
| | Newtabfooter |
|---|
| alias | Legal |
|---|
| url | https://www.idera.com/legal/termsofuse |
|---|
|
|