|
(Added Job Traces & Changed Layout)
|
(Added in step & command traces)
|
| Line 13: | |||
| === SQL to Set All Running Jobs to a Status === | === SQL to Set All Running Jobs to a Status === | ||
| <pre>UPDATE JOB_TRACE SET STATUS = 'XX' WHERE STATUS = 'YY';</pre> | <pre>UPDATE JOB_TRACE SET STATUS = 'XX' WHERE STATUS = 'YY';</pre> | ||
| + | == Job Step Traces == | ||
| + | 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> | ||
| + | == Command Traces == | ||
| + | Usually hidden behind the scenes, these might also need updated if any of the prior failed. | ||
| + | === SQL to Set All Running Command Traces to a Status === | ||
| + | <pre>UPDATE JOB_STEP_CMD_TRACE SET STATUS = 'XX' WHERE STATUS = 'YY';</pre> | ||
