Transact-SQL Reference
sysjobservers
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 = Succeed |
| 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. |