sysjobservers System Table - SQL Server 2000

Stores the association or relationship of a particular job with one or more target servers.

Column nameData typeDescription
job_iduniqueidentifierJob identification number.
server_idintServer identification number.
last_run_outcometinyintOutcome for the job's last run: 0 = succeed; 1 = fail; 2 = cancel.
last_outcome_messagenvarchar(1024)Associated message, if any, with the last_run_outcome column.
last_run_dateintDate the job was last run.
last_run_timeintTime the job was last run.
last_run_durationintDuration of the job's run, in seconds.