| purge jobs in apex [message #547968] |
Mon, 19 March 2012 05:47 |
 |
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
|
Member |
|
|
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?
regards,
Sathish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
