You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/relational-databases/system-tables/dbo-sysjobsteps-transact-sql.md
+2-2Lines changed: 2 additions & 2 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -35,9 +35,9 @@ ms.author: carlrab
35
35
|**flags**|**int**|Reserved.|
36
36
|**additional_parameters**|**ntext**|Reserved.|
37
37
|**cmdexec_success_code**|**int**|Error-level value returned by **CmdExec** subsystem steps to indicate success.|
38
-
|**on_success_action**|**tinyint**|Action to be performed when a step is executed successfully.|
38
+
|**on_success_action**|**tinyint**|Action to be performed when a step is executed successfully.<br /><br /> **1** = (default) Quit with success<br /><br /> **2** = Quit with failure<br /><br /> **3** = Go to next step<br /><br /> **4** = Go to step _on_success_step_id_|
39
39
|**on_success_step_id**|**int**|ID of the next step to execute when a step is executed successfully.|
40
-
|**on_fail_action**|**tinyint**|Action to be performed when a step is not executed successfully.|
40
+
|**on_fail_action**|**tinyint**|Action to be performed when a step is not executed successfully.<br /><br /> **1** = Quit with success<br /><br /> **2** = (default) Quit with failure<br /><br /> **3** = Go to next step<br /><br /> **4** = Go to step _on_fail_step_id_|
41
41
|**on_fail_step_id**|**int**|ID of the next step to execute when a step is not executed successfully.|
42
42
|**server**|**sysname**|Reserved.|
43
43
|**database_name**|**sysname**|Name of the database in which **command** is executed if **subsystem** is TSQL.|
0 commit comments