Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » purge jobs in apex (apex 4.0)
purge jobs in apex [message #547968] Mon, 19 March 2012 05:47
Messages: 56
Registered: September 2011
Location: mumbai
Hi ,

I have a situation where I create a job using APEX_PLSQL_JOB. The process that it is executing will take a long time to run. After a while I decide that I need to end this job since it's slowing down the server. How can I terminate it?

I've tried the following:
- Kill the Oracle session that is executing the code. This terminated the process but just restarted it again a few seconds later
- Purge the process using APEX_PLSQL_JOB.PURGE_PROCESS. This removed it from the list of APEX PL_SQL jobs in the APEX_PLSQL_JOBS view. It had no effect on the processing of the job.

Any other ideas on how I can kill the process that I started?

Previous Topic: Best Oracle Application Express Book
Next Topic: can I make LOV conditional for Radio Buttons?
Goto Forum:

Current Time: Mon Jun 24 08:35:46 CDT 2024