Applies To: SQL Server 2014, SQL Server 2016 Preview
Stores the association or relationship of a particular job with one or more target servers.This table is stored in the msdb database.
Applies to: SQL Server (SQL Server 2008 through current version).
Job identification number.
Server identification number.
Outcome for the job's last run:
0 = Fail
1 = Succeed
3 = Cancel
Associated message, if any, with the last_run_outcome column.
Date the job was last run.
Time the job was last run.
Duration that the job was run, in hours, minutes, and seconds. Computed by using the formula: (hours*10000) + (minutes*100) + seconds.