Page History
To access the Monitored the Job Chains view view, go to the Jobs tab, and select the Jobs tab. Select Job Chains from the options on the top right corner. from the drop down list available in the View By section.
On the 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 Run - the last date and time (including the time zone) when the last job in the chain run.
- Next Run Run - the next date and time (including the time zone) when the next job will run.
- Scheduled Scheduled - if the first job (root job) in the chain is scheduled or not
- Number of Jobs 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 the options you can execute on Job Chains.
Tip |
---|
Click the more options icon to select the information you want to hide or show on the Job Chains view. |
How do you filter the information on the Job Chain view?
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 select the names of the job chains for which you want to see the information.
- Enabled Enabled - filter according to whether the Job Chain is enabled or not.
- Job Name - type select the name of those jobs for which you want to display job chains information.
- Instances Instance - type select the name of those SQL Server Instances for which you want to view job chain information.
- Duration - use the sliders slider 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:
|
What other options are available on the
...
Job Chains view?
On the top section of the Monitored the Job Chains view view, you can find the following options:
- View By - select the jobs (monitored jobs, job trends, job chains, tasks, job history, or task history) you would like to see.
- Add Job Chain - use this option to create a new job chain. Go
...
...
- to find more information.
- Edit Job Chain - select a job chain and click this option to access
...
- the Job Chain wizard
...
- where you can edit the general settings of the job chain, the root job schedules, and the respective alerts.
- View Job Chain Designer - this option is only available if you select a job chain from the list. Select this option and access
...
- the Job Chain Designer
...
- view. You can add, remove jobs, or edit their execution conditions settings.
- Export - select this option to export the information displayed on the
...
- Job Chains
...
- view. You can export as a PDF, CSV, or XML file.
- Refresh - use
...
- this Refresh icon to get the latest information from your job chains
...
- .
Tip |
---|
You can define how many jobs you want to view per page. Go to the bottom section of the tab and type the number of jobs you want to see per page. |
Warning |
---|
Take into account that Read-only users can only access a read-only view of the job properties. Only Administrators and Guest-users can add/edit jobs or add/edit job chains. |
Scroll pdf ignore | ||||||
---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >
...
...