Event Chains: Create SQL Server Event Workflows

Event Chains in the SQL Sentry Event Calendar helps you create workflows containing SQL Server agent jobs or Windows scheduled tasks from any server that you’re currently monitoring.

Each event chain is a series of dependencies between events running on the same server or different servers.

There’s no limit to the length of a chain or the number of events it can contain. You can create workflows that continue conditionally based on the success, failure, or completion of the previous step in the workflow.

You only need to schedule the first node of the event chain, and the following steps will be kicked off through SQL Sentry. Whether a step takes five minutes or an hour, the next step won't start until the previous one completes.

You have three options for setting up your event chain workflows:

1. Proceed upon completion of the previous node

2. Proceed upon success of the previous node

3. Proceed upon failure of the previous node

These options are especially useful if you have a situation where a specific job or task needs to run to correct a failure on a node before the completion of the chain. They’re also helpful when you want to ensure that jobs such as backup jobs don't run concurrently.