13. Chaining and Queuing
Did you ever wish you could find just a few more hours in your maintenance window, or need to have jobs run in a particular sequence?
The advanced chaining features in SQL Sentry Event Manager can assure that interdependent jobs run in the proper order without wasting time or resources.
Chaining
SQL Sentry Event Manager allows you to chain SQL Agent Jobs, Windows Tasks, or Oracle Jobs across servers. You can enforce dependencies and automate workflow throughout your entire enterprise, even across platforms! The graphical chaining interface allows you to design the workflow using variables such as completion, success, or failure. More details are available in the User Guide, but take a few minutes to watch our two video tutorials on chaining -
Graphical Chaining Interface and Advanced Chaining.
Queuing
Event Manager can also keep lower priority jobs from stealing resources and slowing the performance of higher priority jobs. The Queuing feature allows you to temporarily pause the execution of lower priority jobs to prevent resource contention while the higher priority job runs. As soon as it's complete, you can configure the queued job to start immediately after leaving the queue, or resume its normal schedule. More details can be found in the SQL Sentry User Gude.
|