Kommentar
Å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.
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 3 = Cancel |
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. |