Quick Search

Advanced Search »

Discuss (0) History

sysjobservers System Table - SQL Server 2000

RSS

Modified on Fri, May 01, 2009, 10:59 AM by Administrator Categorized as SQL Server System Tables

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 = succeed; 1 = fail; 2 = 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.

Jasinski Technical Wiki