sysjobservers (Transact-SQL)
Stores the association or relationship of a particular job with one or more target servers.
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 of the job's run, in seconds. |