|
(→Job Traces)
|
(→Job Step Traces)
|
| Line 52: | |||
| == Job Step Traces == | == Job Step Traces == | ||
| More rare than the previous two, the step itself can still have a leftover status. | More rare than the previous two, the step itself can still have a leftover status. | ||
| - | === SQL to Set All Running Step Traces to a Status === | ||
| - | <pre>UPDATE JOB_STEP_TRACE SET STATUS = 'XX' WHERE STATUS = 'YY';</pre> | + | <table border=2 cellspacing=2 cellpadding=2 align=center> |
| + | <tr> | ||
| + | <th bgcolor=#000000><font color=white>Type</font></th> | ||
| + | <th bgcolor=#000000><font color=white>SQL</font></th> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td align=center bgcolor=#808080><font color=white>set all running step traces to a status</font></td> | ||
| + | <td><font face=monospace>UPDATE JOB_STEP_TRACE SET STATUS = 'XX' WHERE STATUS = 'YY'</font></td> | ||
| + | </tr> | ||
| + | </table> | ||
| == Command Traces == | == Command Traces == | ||
| Usually hidden behind the scenes, these might also need updated if any of the prior failed. | Usually hidden behind the scenes, these might also need updated if any of the prior failed. | ||
