Export (0) Print
Expand All
Expand Minimize

sysjobservers

SQL Server 2000

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft