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

sysjobsteps System Table - SQL Server 2000

RSS
Modified on Fri, May 01, 2009, 10:59 AM by Administrator Categorized as SQL Server System Tables
Contains the information for each step in a job to be executed by SQL Server Agent. This table is stored in the msdb database.

Column nameData typeDescription
job_iduniqueidentifierID of the job.
step_idintID of the step in the job.
step_namesysnameName of the job step.
subsystemnvarchar(40)Name of the subsystem used by SQL Server Agent to execute the job step.
commandnvarchar(3200)Command to be executed by subsystem.
flagsintReserved.
additional_parametersntextReserved.
cmdexec_success_codeintError-level value returned by CmdExec subsystem steps to indicate success.
on_success_actiontinyintAction to be performed when a step is executed successfully.
on_success_step_idintID of the next step to execute when a step is executed successfully.
on_fail_actiontinyintAction to be performed when a step is not executed successfully.
on_fail_step_idintID of the next step to execute when a step is not executed successfully.
serversysnameReserved.
database_namesysnameName of the database in which command is executed if subsystem is TSQL.
database_user_namesysnameName of the database user whose account will be used when executing the step.
retry_attemptsintNumber of retry attempts made if the step fails.
retry_intervalintAmount of time to wait between retry attempts.
os_run_priorityintReserved.
output_file_namenvarchar(200)Name of the file in which the step's output is saved when subsystem is TSQL or CmdExec.
last_run_outcomeintOutcome of the previous execution of the job step.
last_run_durationintAmount of time incurred in the previous execution of the job.
last_run_retriesintNumber of retry attempts in the last execution of the job step.
last_run_dateintDate of the job step's previous execution.
last_run_timeintTime of the job step's previous execution.

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