APEX

Hi,

I'm wondering if there's a good way to kill jobs that were created using APEX_PLSQL_JOB.

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?

Thank you,

Martin
-----
[http://apex-smb.blogspot.com/]