Managing agent jobs for SQL Server across multiple servers and instances is difficult without the right tools. Failing jobs that do not complete on time can slow performance, cause added down time, and result in data loss. SQL Enterprise Job Manager monitors and manages SQL Server agent jobs and Windows tasks. The familiar calendar layout makes it easy to view status, manage details, and review history for any job or instance in your environment.
Survey of users of SQL Enterprise Job Manager
Manage jobs across multiple instances from a single console. Easily build, modify, or delete any job with few simple clicks.
Define maintenance windows for specified instances. Configure jobs to run only within maintenance windows, and disable jobs and alerts not to run.
View intuitive job summary with at-a-glance overview of job environment. View alert summary, and schedule of day’s jobs and their status.
See jobs and status in familiar calendar layout in calendar schedule. View job schedules across all instances and drill-down for more details.
Use predefined and custom filters to quickly search and sort through jobs against specific parameters.
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.
The server performance timeline provides overview of running jobs across instances as compared to CPU cycles being consumed to identify performance hogs.
The job overlap view provides details on overlapping job runtimes so scheduling can be adjusted to limit conflicts.
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 and manage Windows Server Agent jobs alongside SQL Server jobs in a single tool to improve productivity and enable cross-platform job management.
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.
See run history of all monitored jobs. Job history page provides overviews of each job’s status, run duration, and summary of results.
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.
SQL Enterprise Job Manager is designed to manage jobs across your entire SQL Server environment.
Customize job status collection interval by instance to optimize balance between performance and data.
Run as a stand-alone web application without need for Microsoft Internet Information Services (IIS).
Provide access via intuitive web-based user interface. Sign on and use remotely from anywhere.
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 instances running on cloud virtual machines —such as Azure VM and Amazon EC2.
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).
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.
Everything you need to know, all in one downloadable PDF
Learn how to simplify monitoring and management of SQL Server agent jobs
Learn how to explore top monitored instances, focus on problematic occurrences, and more.
Learn more about SQL Server agent jobs and how to better manage them
K. Brian Kelley shows how to manage the menagerie of multiple SQL Servers and their jobs
Learn how to manage and schedule a large numbers of SQL Server, jobs across the enterprise