Jaa


sysjobservers (Transact-SQL)

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.