It's all about the answers!

Ask a question

how to cancel a job no longer running in BF agent?


Michael Dang (1334) | asked Aug 27 '14, 9:34 a.m.
 Hi all,

In the middle of the job running, Oracle Database hang because the .edit command produce millions millions output to step logs; Build Forge no longer reponse. After bring down database, Build Forge, and up again running; The job shows running; but no longer running in Build Forge agent. 

I CANNOT be able to cancel the job.

Any idea? please help.

Thanks
Michael

Accepted answer


permanent link
Ryan Ruscett (1.0k413) | answered Aug 27 '14, 9:51 a.m.
Hey.

Stop Build Forge and be sure that ALL the Build Forge processes on the server are stopped.

The easiest way to do this is to just set all Running Jobs to completed. 
UPDATE bf_builds SET bf_state='C' WHERE bf_state='R'

Please note that if any other jobs are running, they will be marked complete. So make sure there are no jobs running which if Build Forge is shut down wont be a problem come to think of it lol. 

Run the SQL command and you should be all set. It will take the job and just put it int he completed state so you can purge it later. 

If you have to have the job to reflect cancelled. There is more to do. So as I mentioned. This is the easiest way. 

Thanks for using the Forum - We work off "likes" so if this helps, please let us know. 
    

Spencer Murata selected this answer as the correct answer

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.