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:
- Select one of the existing jobs listed under the Job Name section on the left pane of the Job Designer view, drag and drop it in the designer space. SQL Enterprise Job Manager opens a dialog window with the following options:
- Add to job chain - select this option to add the selected job without changes to the job chain.
- Do not add to job chain - select this option if you do not want to add the job to the job chain.
- Clone job as and add job in chain - use this option if you want to clone/copy the selected job and add it to the job chain.
- Add to job chain and disable its schedule - select this option to add the selected job without its respective schedule.
You can also access the Job Designer view of a previously created job chain on the Job Chains view. Select the respective job chain from the list and click View Job Chain Designer from the top bar options.
To go from the Job Designer view to the Job Chains view, click the option Back to Job Chain located on the top right corner.
How do you define the execution condition of each job?
The execution of each job in the job chain is defined by a setup condition of the previous job. To define this execution condition, follow these steps:
- Double-click a job in the job chain designer. The Job Chain Execution Condition dialog window opens and displays related jobs.
- To define Execution Conditions, select a job and choose Failure or Success from the drop-down Execution Conditions options.
- Click SAVE.
How do you delete jobs from the job chains?
In order to delete job nodes from the job chain, follow these steps:
- 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 - select the name of the jobs you want to view.
- Instance - select 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.
When using filters take into account:
- Some filters have the option to Add Filter in case the information you are looking for is not listed. Once you click on Add Filter, a dialog box appears. Type the name you are looking for on the Search bar, then select it from the list, and Save. Your filter will be included under the filter list where you Added.
- Click the respective checkbox to add or remove your selections.
- If you want to select filters first and apply the changes later, deselect the Apply Filter Instantly option.
- To remove filters, use the specific Clear Filter option in each filter. For example, if you want to remove your Instance filters, click Clear Filter under the same filter section.
- Under Applied filters on the top section of your Job Chain view, you can see the filters you have selected. Click the X icon next to the ones you want to remove.
- Use the option Clear All Filters on the top section of the Filter Table By to remove all filters.
- If you want to save your preferred filtering options, type a name in the Add Filter wizard of the Custom Filter section, and click Save. Once you save your filter, you can retrieve it from the drop-down bottom of the Custom Filter option available in the left side under the Filter Table By section.
What other options do you have on the Job Designer view?
On the top right section of the panel, you can find the following options:
- Back to Job Chain - this option takes you back to the Monitored Job Chains view.
- Add New Job - this option allows you to open the wizard for adding a new job. Specify the settings for the respective new job. SQL Enterprise Job Manager adds this new job to the list of available jobs on the left pane. You can select (drag and drop) this job and add it to your Job Chain.
- Help - the help icon sends you to this Wiki documentation.