Monitor and manage agent jobs across database instances

View job status and details with familiar calendar layout
Chain jobs together to build automated workflows
Configure and manage jobs that run over multiple instances
Set alerts to be notified of potential issues

Performance Monitoring

• Manage with centralized console

  Manage jobs across multiple instances from a single console. Easily build, modify, or delete any job with few simple clicks.

• Use maintenance mode

  Define maintenance windows for specified instances. Configure jobs to run only within maintenance windows, and disable jobs and alerts not to run.

• Summarize jobs

  View intuitive job summary with at-a-glance overview of job environment. View alert summary, and schedule of day’s jobs and their status.

• View calendar schedule

  See jobs and status in familiar calendar layout in calendar schedule. View job schedules across all instances and drill-down for more details.

• Filter jobs

  Use predefined and custom filters to quickly search and sort through jobs against specific parameters.

 

Job Management & Analysis

• Create and modify jobs

  Create new SQL Server agent jobs or modify existing jobs on a single instance or across multiple ones. Job wizard provides step-by-step guidance through the job creation process.

• Identify Performance Issues

  The server performance timeline provides overview of running jobs across instances as compared to CPU cycles being consumed to identify performance hogs.

• Schedule jobs and resolve conflicts

  The job overlap view provides details on overlapping job runtimes so scheduling can be adjusted to limit conflicts.

• Analyze job trends

  Analyze job execution results by day, week, month, or year to identify trends and tune performance. View trends like top failed jobs, most frequently run jobs, and longest running jobs.

• Monitor Windows Server Agent jobs

  Monitor and manage Windows Server Agent jobs alongside SQL Server jobs in a single tool to improve productivity and enable cross-platform job management.

• Setup alerts and notifications

  Create job alerts and set up email notifications to stay informed and on top of issues as they happen. Set custom alert thresholds to receive tailored notifications.

• View job history

  See run history of all monitored jobs. Job history page provides overviews of each job’s status, run duration, and summary of results.

• Copy jobs

  Easily copy jobs and apply to another instance or use them as starting points for quick creation of similar jobs. All original details of jobs are loaded into the job creation wizard.

 

Web-based Architecture

• Scale across enterprise

  SQL Enterprise Job Manager is designed to manage jobs across your entire SQL Server environment.

• Optimize performance

  Customize job status collection interval by instance to optimize balance between performance and data.

• Install lightweight web console

  Run as a stand-alone web application without need for Microsoft Internet Information Services (IIS).

• Deploy easily

  Provide access via intuitive web-based user interface. Sign on and use remotely from anywhere.

 

Cloud

• Install on cloud virtual machines

  Unify your control by running SQL Enterprise Job Manager on cloud virtual machines—such as Azure Virtual Machine (VM) and Amazon Elastic Compute Cloud (EC2).

• Monitor SQL Server on cloud virtual machines

  Monitor SQL Server instances running on cloud virtual machines —such as Azure VM and Amazon EC2.

• Monitor hybrid environments with single tool

  Save time by using the same performance-monitoring tool for SQL Server databases on-premises (on your physical and virtual machines); and in private, public, and government cloud (on virtual machines).

• Access mapped cloud drives

  Get most out of cloud with cloud storage that is mapped as network drives or removable drives on Windows with SQL Enterprise Job Manager. For example, map storage to Amazon Simple Storage Service (S3) and Azure Blob Storage..

IDERA Dashboard services requirements

You need to comply with the following requirements to install the IDERA Dashboard:

Type : Microsoft .NET Framework version
Requirement : 4.0 or later
Suggestions : Make sure to install this software prior to the installation of the IDERA Dashboard. For more information about the .NET Framework, see the MSDN article .NET Framework Versions and Dependencies.


Type : Microsoft Library
Requirement : msolap.dll
Suggestions : The msolap.dll file needs to be installed where the data collection service runs. The installation will search for the file and if it is not found, it will prompt the user to install the file. This file can be installed by downloading and installing from the latest version of the SQL Server Feature Pack from Microsoft SQL Server 2016 Feature Pack (choose the ENU\x64\SQL_AS_OLEDB.msi installer).

Type : Operating System
Requirement :

• Windows Server 2008 R2 (86-bit)
• Windows Server 2008 R2 (64-bit)
• Windows Server 2012 R2 (64-bit)
• Windows Server 2016 (64-bit)
• Windows 10 (64-bit)
• Windows 2019 (64-bit)

Suggestions : -

 

IDERA Dashboard repository requirements

The IDERA Dashboard supports any of the following versions for hosting its repositories:

• SQL Server 2008 R2 - All Editions
• SQL Server 2012 R2 - All Editions
• SQL Server 2014 - All Editions
• SQL Server 2016 - All Editions
• SQL Server 2017
• SQL Server 2019

Browser requirements

The IDERA Dashboard user interface can be accessed via web with the following browsers:

• Internet Explorer IE 10.x+
• Google Chrome
• Mozilla Firefox
• Microsoft Edge
• Safari

Port requirements

The IDERA Dashboard uses the following ports by default:

• Idera Dashboard Core Services port: 9292
• Idera Dashboard Web Application Service port: 9290
• Idera Dashboard Web Application Monitor port: 9094
• Idera Dashboard Web Application SSL port: 9291