Solution Marketplace

SQL Sentry Event Manager® is the ultimate scheduling, alerting and response system for optimizing schedule performance of database servers and related IT resources. Event Manager provides DBAs with "Outlook-style" visibility and functionality for managing SQL Agent jobs, Windows Tasks, and Oracle jobs in increasingly complex cross-platform environments. Event Manager for SQL Server does not replace SQL Server Agent scheduler. In fact, that is a key differentiation between Event Manager and most other scheduling products. With Event Manager there are no agents to install and manage on each server. Event Manager for SQL Server provides a visual display of SQL Agent jobs along with other events across the enterprise so that the DBA can “see” how they relate to one another and optimize the schedules more efficiently.

Designed in response to the needs of high performance database environments, Enterprise Edition (EE) delivers the tools and productivity necessary to manage intricate and voluminous job streams, including support for geographically distributed deployments and configuration of powerful cross-server event chains. Event Manager includes visual schedule management, schedule performance monitoring, alerting and response actions, graphical reporting, and advanced chaining and queuing for SQL Server 2000, SQL Server 2005, SQL Server 2008, Oracle (8i, 9i, 10g) and Windows Task Scheduler.

• Visual Schedule Management: See your complex event schedules in a whole new light with Event Manager's robust, Outlook-style visual calendar with drag-and-drop rescheduling. The flexible interface allows simultaneous display of multiple calendars and graphs, and supports both full and split screen modes. Slice and dice schedules across servers with the Global Calendar, Group Calendars, and Custom Event Views. Easily assess contention levels across "shared resources" such as file storage areas, tape libraries, network segments, etc.
• Alerting and Response System: Event Manager EE employs the most comprehensive and reliable notification system available today for SQL Server and Oracle, providing a wide variety of response actions to any event status, runtime or performance condition. You can even generate notifications for Windows Task Scheduler, Reporting Services, and other event sources.
• SSIS and DTS Support: Enable detailed logging for both SSIS and DTS packages with a few clicks, and view the results on the SQL Sentry calendar and history list views alongside any other events on a server. Accessing error details for failed package steps has never been simpler!
• Cross-platform Support: Using a plug-in architecture, Event Manager EE seamlessly integrates event data from SQL Server, Oracle, Windows Scheduler and others together in one console, so you get the full picture. Event Manager doesn't replace your existing schedulers, it makes them work better.
• Chaining and Queuing: Easily enforce dependencies between SQL Server, Oracle and Windows Scheduler across your environment. Event Manager is the first system enabling automation and integration across different scheduling systems, ensuring precise control over which events run and when.
• Schedule Performance Monitoring: Link any Windows performance counter directly to an event or custom view and see the impact any combination of events is having on Windows servers or shared resources. Counters are instantiated as needed for minimal server and network overhead.
• Graphical Reporting: Event runtime graphs enable quick trend analysis, and Gantt-style performance graphs highlight the events competing for resources and causing end user performance problems. Event history and other list views can be easily exported to .HTML, .XML, or .CSV format.
• Reporting Services Support: Event Manager provides complete scheduling, monitoring and notification features for SQL Server Reporting Services. This enables a DBA to view all Reporting Services events on the Event Manager calendar, monitor their impact on performance and set notifications ensuring awareness of any issue. Event Manager maps the awkward job GUIDs to friendly report names, and performance counters can be linked to any Reporting Services task, including individual subscriptions and report execution snapshots.