SQL Server Job Chaining and Queuing: SQL Sentry Event Manager
customer portal        

Chaining and Queuing


Event Manager's advanced chaining features enable you to quickly and easily define dependencies and workflows involving SQL Agent jobs, Oracle jobs, and/or Windows Tasks. You have ultimate flexibility with regard to how the chains are defined - the chained jobs or tasks can reside anywhere in the enterprise, and you can have unlimited levels per chain, as well as unlimited jobs/tasks per level.

Features

  • Easy configuration of powerful cross-server job chains.
  • Define dependencies between events occurring on disparate systems. For example, run a SQL Server job whenever a Windows task completes successfully.
  • Graphical Interface for easy of configuration and printing of chain diagrams.
  • No limit to length or complexity of chain.
  • Works with your existing scheduling agents - no new schedulers are installed.
  • Job Queuing
    Event Manager's advanced queuing features make it easy to prevent job conflicts related to occasional runtime deviations, and enforce inter-job dependencies. You can set a job to queue or be queued for a specified time, limit the total number of jobs in the queue at any one time, and control a job's behavior when it pops off the queue.

    The "Execute Job" Action
    For simpler 1-to-1 chaining scenarios, you can utilize the "Execute Job" action to trigger a job on any SQL Server in response to any other event status or performance condition, for any event type.

    Learn more about job queuing and chaining in our white papers - Job Queuing and Job Automation.

    * Job Queuing is not supported on the Oracle platform.

     

     
    Product Evaluation
     

    Download Performance Advisor and Event Manager Enterprise Edition


    Enterprise Edition
    SQL Server
    Oracle
    Windows Task Scheduler

    Standard Edition
    SQL Server
    Windows Task Scheduler

    Event Manager Features
    Visual Schedule Management
    Alerting and Response
    SSIS and DTS Support
    Cross-platform Support
    Chaining and Queuing
    Schedule Performance Monitoring
    Graphical Reporting
    Enterprise vs. Standard Edition

    White Papers
    Monitoring Disk Contention
    Global Event Actions
    Eliminating Backup Contention
    SQL Server 2005 Migration
    Log Shipping and Replication
    Job Queuing
    Job Automation
    SQL Server Virtualization

    More About Event Manager
    Video Tutorials
    System Architecture
    Awards and Reviews
    Price List/Online Store
    ROI Calculator
    Product Datasheet

    performance advisor | event manager | site map | privacy | contact us | about us | sales@sqlsentry.net | 704.895.6241
    © 2009 SQL Sentry, Inc. All rights reserved.