Page History
After using the Add Job Chain option to specify the general characteristics of your new job chain, the root job, its schedules, and its respective alerts, you can add more jobs to the job chain by using the Job Chain designer. You can add as many jobs as you want.
How do you use the Job Chain designer?
After you create your job chain, SQL Enterprise Job Manager displays the first job (root job) on the Job Designer view. To add more jobs:
...
| Tip |
|---|
To go from the Job Designer view to the Monitored Job Chains view, click the option Back to Job Chain located on the top left corner. |
How do you define the execution condition of each job?
The execution of each job in the job chain is defined by a set up condition of the previous job. To define this execution condition, follow these steps:
...
| Note |
|---|
| Take into account that the Root Job depends on its schedules and not executions conditions; hence when you double click the Root Job on the Job Designer, SQL Enterprise Job Manager opens the Add Job Chain wizard to access the Root Job settings. |
How do you delete jobs from the job chains?
- Double-click the respective job
- The Job Chain Execution Condition dialog window opens and displays all related jobs.
- Select the job and click DELETE.
Take into account that when you delete a node in the job chain, all its dependent jobs will be deleted as well.
How do you filter information on the Job Chain Designer?
To filter the list of available jobs on the Job Designer view, you can use the following options:
- Job name - type the name of the jobs you want to view
- Instance - type the name of the SQL Server instances for which you want to see its jobs
- Category - select those job categories for which you want to see its jobs
What other options do you have on the Job Designer view?
On the top left section of the left panel, you can find the following options:
...