| title | dbo.sysjobservers (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 08/26/2019 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine | ||||
| ms.reviewer | |||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 9abcc20f-a421-4591-affb-62674d04575e | ||||
| author | stevestein | ||||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Stores the association or relationship of a particular job with one or more target servers. This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
| job_id | uniqueidentifier | Job identification number. |
| server_id | int | Server identification number. |
| last_run_outcome | tinyint | Outcome for the job's last run: 0 = Fail 1 = Succeed 2 = Retry 3 = Cancel 4 = In progress 5 = Unknown (see the following Remarks section) |
| last_outcome_ message | nvarchar(1024) | Associated message, if any, with the last_run_outcome column. |
| last_run_date | int | Date the job was last run. |
| last_run_time | int | Time the job was last run. |
| last_run_duration | int | Duration that the job was run, in hours, minutes, and seconds. Computed by using the formula: (hours*10000) + (minutes*100) + seconds. |
A value above 4 means that the SQL Agent does not know the state of that job. The last_run_outcome is initially set to 5 when a job gets created.