Megosztás a következőn keresztül:


sysjobservers (Transact-SQL)

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.

See Also

Other Resources