2 Replies Latest reply: Apr 26, 2013 1:07 AM by chiti RSS

    apex_plsql_job.submit not working

    chiti
      Hi All,

      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

      Thanks
      Raj
        • 1. Re: apex_plsql_job.submit not working
          Hari_639
          RajEndiran wrote:
          Hi All,

          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

          Thanks
          Raj
          Hell Raj,

          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
          Regards,
          Hari
          • 2. Re: apex_plsql_job.submit not working
            chiti
            Hi Hari,

            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.

            Regards
            Raj