View Jobs in Lists
You can view information about all SQL Server jobs and Windows tasks for a selected server. You can also configure Job Manager to view each step in a job, and the execution history.
NOTE: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To view a job/task in a list
on the toolbar or select Tools | Administer | Job Manager.
- Select a server
- Review the following for additional information:
Column
Description
Job Name
Displays the name of the job. The icon before the job name indicates the application that created it:
- Native SQL Server
- LiteSpeed
- Maintenance Plans
- Alert
- Unknown application or Toad
Schedule
Displays the schedule and indicates whether the job/task runs only once, runs on a regular basis, or starts automatically.
Last Result
Displays the status for the last job/task run as follows:
- This job/task has never run.
- Last job/task successfully ran.
- Last job/task failed.
Note: Jobs are grouped by instance name. Tasks are grouped by server name.
- To view job steps and execution history, configure Job Manager. For more information, see Job Manager Options.
- If you configured Job Manager to display history on demand, click Show History to view information about each step in the job's execution.
TIP: Right-click a job/task to start or stop it, create a new job/task, or perform other functions.
You can also manage jobs in the Object Explorer. Select Agent | Jobs, right-click a job and select an option.