Page History

Versions Compared

changes.mady.by.user Unknown User (6092aebacc7830006a5cfc58)

Saved on Mar 08, 2016

compared with

changes.mady.by.user Unknown User (6092aebacc7830006a5cfc58)

Saved on Mar 31, 2016

...

On the Job Chains view you can find all job chains defined in your environment. In this list you can see the following information:

Job Chain Name - the name specified for your job chain
Enabled - if the job chain is enabled or disabled
Job Chain Status - current status of the job chain. This status could be: Executing, Idle, Error, Cancelled, or Unknown.
Last Run Outcome - the general outcome of the job chain. For a specific status, all jobs in the chain must have that status. For example to show a "Success" status, all jobs in the chain should have completed successfully.
Last Run Duration - the duration of the job chain in hh:mm:ss
Last Run - the last date and time (including the time zone) when the last job in the chain run.
Next Run - the next date and time (including the time zone) when the next job will run.
Scheduled - if the first job (root job) in the chain is scheduled or not
Number of Jobs - number of jobs in the job chain
Number of Instances - Number of SQL Server instances included in the job chain
Actions - Click click this option to access the options you can execute on Job Chains.

...

To see more specific information about your job chains, filter your information using the options available on the left section of this view.

You can filter by:

Job Chain Status - filter by the current status of the job chain, this refers to the status of the last job to run. This status can be: Executing, Idle, Error, Cancelled, or Unknown.
Job Chain Name - type the names of the job chains for which you want to see the information.
Enabled - filter according to whether the Job Chain is enabled or not.
Job Name - type the name of those jobs for which you want to display job chains information.
Instances - type the name of those SQL Server Instances for which you want to view job chain information.
Duration - use the sliders to filter by the duration of the job chain
Job Chain Outcome - filter by the general outcome of the job chain. This status can be: Failed, Succeeded, or Unknown. Take into account that in order to have a Succeeded status, all jobs in the chain must be successful.

Tip
When using filters take into account: If you want to select filters first and apply the changes later, unselect the option Apply filter as it changes. To remove filters, use the specific Remove Filter option in each filter. For example, if you want to remove your Instance filters, click Remove INSTANCE Filter under the same filter section. Under FILTERED BY on the top section or your Job Trend 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 on the top section of the Filtering section to remove all filters.

Tip

When using filters take into account:

If you want to select filters first and apply the changes later, unselect the option Apply filter as it changes.
To remove filters, use the specific Remove Filter option in each filter. For example, if you want to remove your Instance filters, click Remove INSTANCE Filter under the same filter section.
Under FILTERED BY on the top section or your Job Trend 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 on the top section of the Filtering section to remove all filters.

...