What is Job Chaining?
SQL Enterprise Job Manager allows you to tie several jobs together across multiple SQL Server instances. A Job Chain lets you create dependencies among jobs and schedule their execution in one server or across multiple servers. You can define your desired execution sequence so that you identify which jobs you want to run after another.
How do you access the Job Chains view?
To access the Job Chains view, go to the Jobs tab. Select Job Chains from the drop down list available in the View By section.
How are Job Chains Scheduled?
When you create a Job Chain, you specify a root job for which you define a schedule. The following jobs run according to the execution status of the preceding job.
Click the following sections to know what information is available on the Job Chains view, what actions you can perform on Job Chains, how to add a new Job Chain, and how to use the Job Designer to create Job Chains.