|
(Adding appropriate statuses for WorkflowCases)
|
(Combined into one massive section & put appropriate selectors)
|
| Line 78: | |||
| </tr> | </tr> | ||
| </table> | </table> | ||
| - | == Job Traces == | + | == Job Traces, Job Step Traces, and Command Traces == |
| - | Much like Workflow Cases, Job Traces can fail to update if an event to end the job does not fire. | + | Much like Workflow Cases, Job Traces can fail to update if an event to end the job does not fire. Also, while more rare than the previous, the step itself can still have a leftover status. Additionally, command traces, while usually hidden behind the scenes, these might also need updated if any of the prior failed. |
| <table border=2 cellspacing=2 cellpadding=2 align=center> | <table border=2 cellspacing=2 cellpadding=2 align=center> | ||
| <tr> | <tr> | ||
| <th bgcolor=#000000><font color=white>Type</font></th> | <th bgcolor=#000000><font color=white>Type</font></th> | ||
| - | <th bgcolor=#000000><font color=white>SQL</font></th> | + | <th bgcolor=#000000 colspan=2><font color=white>SQL</font></th> |
| </tr> | </tr> | ||
| <tr> | <tr> | ||
| Line 90: | |||
| - | <td><font face=monospace>UPDATE JOB_TRACE SET STATUS = 'XX' WHERE STATUS = 'YY'</font></td> | + | <td colspan=2><font face=monospace>UPDATE JOB_TRACE SET STATUS = 'XX' WHERE STATUS = 'YY'</font></td> |
| + | </tr> | ||
| + | <tr> | ||
| + | <td align=center bgcolor=#808080><font color=white>set all running step traces to a status</font></td> | ||
| + | <td colspan=2><font face=monospace>UPDATE JOB_STEP_TRACE SET STATUS = 'XX' WHERE STATUS = 'YY'</font></td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td align=center bgcolor=#808080><font color=white>set all running command traces to a status</font></td> | ||
| + | <td colspan=2><font face=monospace>UPDATE JOB_STEP_CMD_TRACE SET STATUS = 'XX' WHERE STATUS = 'YY'</font></td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <th bgcolor=#404040 colspan=3><font color=white>SELECTOR (replace XX/YY/ZZ above with one of below)</th> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td align=center bgcolor=lightgrey>Aborted</td> | ||
| + | <td align=center bgcolor=lightgrey>Aborting</td> | ||
| + | <td align=center bgcolor=red>Failed</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td align=center bgcolor=lightgrey>Not Needed</td> | ||
| + | <td align=center bgcolor=lightgrey>Queued</td> | ||
| + | <td align=center bgcolor=lightyellow>Resuming</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td align=center bgcolor=yellow>Running</td> | ||
| + | <td align=center bgcolor=lime>Success</td> | ||
| + | <td align=center bgcolor=orange>Success (Warning)</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td align=center bgcolor=yellow>Suspended</td> | ||
| + | <td align=center bgcolor=red>Timed Out</td> | ||
| + | <td align=center bgcolor=lightgrey>Waiting on Agents</td> | ||
| </tr> | </tr> | ||
| </table> | </table> | ||
