Conditions and Actions
Event Manager can generate email or pager alerts, and take various other actions using event status, runtime, or performance information.
Event Sources:
• SQL Server Agent Alerts
• SQL Server Agent Jobs
• SQL Server Agent Log
• DTS Packages
• Reporting Services
• SQL Server Maintenance Plans
• Windows Tasks
• Oracle DBMS Jobs
• Oracle Enterprise Manager Jobs
• Oracle 10g Scheduler
Conditions (more than 90) including:
• Start / Finish
• Success / Failure
• Step Failure / Retry
• Runtime Threshold Min / Max
• Blocked / Blocking
• Performance Threshold Min / Max
• Queuing / Queued
• Schedule Conflict
• Output Content Match
Actions:
• Send Email
• Send Page
• Execute Process
• Execute SQL
• Execute Job
• Kill Task
• Log to Disk
• Log to Database
• Log to Event Log
Alert Messages
Event Manager goes beyond the limited alerting capabilities built-in to SQL Server, Oracle, and Windows Task Scheduler with messages that include granular, detail-level information. Event Manager alerts contain more of the information you need to quickly evaluate and resolve any job condition, which can dramatically reduce response times.
Supported Alerts:
• Step-level output
• Error codes and descriptions
• Job and performance condition data
• Start / End times
• Job duration
• "Other Active Jobs" list
• Blocking processes, SQL statements,
hostnames and applications
Sample Email Alerts:
Job Blocking
Job Runtime Maximum
Job Step Failure
DTS Output Content Match
Reporting Services Report Failure |
