Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Name - the name specified for your job chain
  • Enabled - if the job chain is enabled or disabled
  • 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 this option to access the options you can execute on Job Chains. 
Tip

Click the  gear  more options icon to select the information you want to hide or show on the Job Chains view.

...

  • 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 Adding new job chains 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  gear  Refresh icon to get the latest information from your job chains.

...