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
      New SQL Sentry Software Version
    Download Performance Advisor for SQL Server, Performance Advisor for Analysis Services, and Event Manager.

    Enterprise Edition
    SQL Server
    Oracle
    Windows Task Scheduler

    Standard Edition
    SQL Server
    Windows Task Scheduler

    White Papers
    Monitoring Disk Contention
    Global Event Actions
    Eliminating Backup Contention
    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
    Product Datasheet

    sql server solutions | analysis services solutions | site map | privacy | contact us | about us | sales@sqlsentry.net | 704.895.6241
    © 2010 SQL Sentry, Inc. All rights reserved.