Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

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 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.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.