|
(→Appendix A: Kill All (May Require Server Restart))
|
(Added CSS styling to the massive SQL query so it fits all on one line)
|
| Line 98: | |||
| <tr> | <tr> | ||
| <td align=center bgcolor=#808080><font color=white>kill everything</font></td> | <td align=center bgcolor=#808080><font color=white>kill everything</font></td> | ||
| - | <td><font face=monospace size=1>DELETE FROM LOCK_HOLDER_LOCK_RES;<br/>DELETE FROM LOCK_HOLDER;<br/>UPDATE JOB_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents');<br/>UPDATE WORKFLOW_CASE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents');<br/>UPDATE JOB_STEP_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents');<br/>UPDATE JOB_STEP_CMD_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents');<br/>UPDATE BUILD_REQUEST SET STATUS = 'Failed' WHERE STATUS IN ('Running','Determining Quiet Period','NA','Restarting');</font></td> | + | <td><p style="font-size:11px"><font face=monospace>DELETE FROM LOCK_HOLDER_LOCK_RES;<br/>DELETE FROM LOCK_HOLDER;<br/>UPDATE JOB_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents');<br/>UPDATE WORKFLOW_CASE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents');<br/>UPDATE JOB_STEP_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents');<br/>UPDATE JOB_STEP_CMD_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents');<br/>UPDATE BUILD_REQUEST SET STATUS = 'Failed' WHERE STATUS IN ('Running','Determining Quiet Period','NA','Restarting');</font></p></td> |
| </tr> | </tr> | ||
| </table> | </table> | ||
