sysjobservers (Transact-SQL)
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. |