|
(Changed to 'Aborted' for compatibility issues)
|
(Had a couple of edge-cases where clients were using "Suspended" as well)
|
| Line 144: | |||
| <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><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 = 'Aborted' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents');<br/>UPDATE WORKFLOW_CASE SET STATUS = 'Aborted' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents');<br/>UPDATE JOB_STEP_TRACE SET STATUS = 'Aborted' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents');<br/>UPDATE JOB_STEP_CMD_TRACE SET STATUS = 'Aborted' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents');<br/>UPDATE BUILD_REQUEST SET STATUS = 'Aborted' WHERE STATUS IN ('Running','Determining Quiet Period','NA','Restarting');</font></p></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 = 'Aborted' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents','Suspended');<br/>UPDATE WORKFLOW_CASE SET STATUS = 'Aborted' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents','Suspended');<br/>UPDATE JOB_STEP_TRACE SET STATUS = 'Aborted' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents','Suspended');<br/>UPDATE JOB_STEP_CMD_TRACE SET STATUS = 'Aborted' WHERE STATUS IN ('Running','Restarting','Aborting','Waiting on Agents','Suspended');<br/>UPDATE BUILD_REQUEST SET STATUS = 'Aborted' WHERE STATUS IN ('Running','Determining Quiet Period','NA','Restarting','Suspended');</font></p></td> |
| </tr> | </tr> | ||
| </table> | </table> | ||
