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