Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
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. |
Remarks
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.