This content has been marked as final. Show 2 replies
RajEndiran wrote:Hell Raj,
We are using apex_plsql_job.submit for the background job. I face no issue until the database is refreshed. Now when i submit any job which uses this function is not submitting at all.
I checked the APEX_PLSQL_JOB.JOBS_ARE_ENABLED and it is enabled .
Am not sure whether the recent refresh is causing the issue, can anyone please help on this?
Thanks in advance.
I am using oracle apex 4.0
What do you mean when you say "database is refreshed"?
BTW have you checked following view to see the status of your job?
select * from APEX_PLSQL_JOBS
The test instance is refreshed.
s i checked in select * from APEX_PLSQL_JOBS but there are no jobs submitted. I also checked if jobs are enabled using APEX_PLSQL_JOB.JOBS_ARE_ENABLED . Ifound the jobs are enabled.