SQL ENTERPRISE JOB MANAGER
- Monitor SQL Server agent jobs across the enterprise
- Easily view job status and details with familiar calendar layout
- Chain jobs together and build automated workflows
- Configure and manage jobs that run over multiple instances
- Set alerts to be notified of potential issues
- Web-based architecture simplifies deployment
Comprehensive Job Monitoring
SQL Enterprise Job Manager provides comprehensive monitoring of SQL Server agent jobs across the entire SQL Server landscape. See what is scheduled to run and when and get up to the minute status information. View jobs by instance or drill down into specific jobs to see alert settings, upcoming jobs, and history details.
Familiar Calendar Layout
View jobs and status in a familiar calendar layout. Jobs are color-coded for quick identification of current, past, and upcoming scheduled jobs as well as jobs that have been manually run.
Create sequences, or chains, of jobs that run automatically one after the other based on the status of a preceding job in the chain. Configure simple to complex chains of jobs that can run either in series or in parallel to each other. The software utilizes a drag and drop interface to schedule the execution order. Job chains can be defined on a single server or span across multiple SQL Server instances.
Create and manage jobs that run over multiple instances to simplify management of common tasks, ensure consistency, and save time. Once created, individual instances can be easily added or removed from the multi-instance job as your environment and needs change.
Build email alerts to be notified of job status or potential issues. Establish alerts for indicators such as when jobs fail or restart, server instance connection failures or when job agents have stopped running.
SQL Enterprise Job Manager is a architected as a web-based management console for easy deployment across the enterprise. Users can login from anywhere with an internet connected PC to monitor and manage their SQL Server agent jobs.
IDERA Dashboard Integration
The IDERA Dashboard is a unified web interface for accessing individual IDERA SQL products together and includes a cross-product dashboard that provides integrated views of status, top issues, and alerts across all installed products. With a few clicks users can easily move between viewing server performance details, to job status information, and to backups depending upon which IDERA SQL products are installed. The integrated IDERA Dashboard provides a single view of important information across products to simplify management of your SQL Server environment.
Enterprise Job Monitoring
Manage jobs across multiple SQL Server instances anywhere in the SQL environment from a single console. Easily build, modify, or delete any job with a few simple clicks.
Define maintenance windows for specified instances. Configure jobs to run only within the maintenance window, disable jobs and alerts not to run, and stop maintenance jobs when the window closes.
The intuitive job summary provides an at-a-glance overview of the job environment. View the alert summary, schedule of the day’s jobs and their status, and an overview of each managed instance. Point and click to get more details and take action.
Calendar Schedule View
The calendar schedule helps you see jobs and status in a familiar calendar layout. View job schedule by day, week, or month across all instances or drill-down into a single one. Jobs are color-coded to help quickly identify the current status, past and future scheduled jobs. To reschedule simply drag and drop.
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. The job wizard provides step-by-step guidance through the job creation process. Select any monitored job to add or edit steps, change the run schedule, or update alerts and notifications.
Job Scheduling and Conflict Resolution
Two capabilities are available to enhance job scheduling efficiency and reduce conflicts. The Server Performance Timeline provides an 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.
Job Trending Analysis
Analyze job execution results by day, week, month, or year to identify trends and tune performance. View trends like the top failed jobs, most frequently run jobs, and longest running jobs. Even forecast job duration increases and compare highest increases over selected time periods.
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.
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 make sure you receive notifications tailored to your environment.
View the run history of all monitored jobs. The job history page provides an overview of each job’s status, run duration, and summary of the results. Filtered views help you quickly get to the information you want. You can also export the data as a .PDF, .CSV, or XML file.
Easily copy a job and apply to another instance or use as a starting point for the quick creation of a similar job. All the original details of the job are loaded into the job creation wizard making it easy to modify just what needs to change.
Web Based Architecture
- Built to manage jobs across your entire SQL Server environment
- Customize the job status collection interval by instance to optimize the balance between performance and data.
Lightweight Web UI
- Stand-alone web application; no need for IIS.
- Intuitive web-based UI; sign on and use remotely from anywhere.