|
(→Lockable Resources & Lock Holders)
|
(→Appendix A: Kill All (May Require Server Restart))
|
| Line 90: | |||
| </table> | </table> | ||
| = Appendix A: Kill All (May Require Server Restart) = | = Appendix A: Kill All (May Require Server Restart) = | ||
| - | <pre>DELETE FROM LOCK_HOLDER_LOCK_RES; | ||
| - | DELETE FROM LOCK_HOLDER; | ||
| - | UPDATE JOB_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents'); | + | <table border=2 cellspacing=2 cellpadding=2 align=center> |
| - | UPDATE WORKFLOW_CASE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents'); | + | <tr> |
| - | UPDATE JOB_STEP_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents'); | + | <th bgcolor=#000000><font color=white>Type</font></th> |
| - | UPDATE JOB_STEP_CMD_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents'); | + | <th bgcolor=#000000><font color=white>SQL</font></th> |
| - | UPDATE BUILD_REQUEST SET STATUS = 'Failed' WHERE STATUS IN ('Running','Determining Quiet Period','NA','Restarting'); | + | </tr> |
| - | </pre> | + | <tr> |
| + | <td align=center bgcolor=#808080><font color=white>kill everything</font></td> | ||
| + | <td><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></td> | ||
| + | </tr> | ||
| + | </table> | ||
| = Appendix B: Status Switch = | = Appendix B: Status Switch = | ||
