Oracle APEX - How to enable jobs thru apex_plsql_job
viveksNov 9 2012 — edited Nov 9 2012I have written code to submit jobs in dev environment thru apex_plsql_job. This is working fine.
We are upgrading our database to 11g from 10g. After upgrading the database I find that the job which was working fine in 10g env in Development is not working in new 11g environment.
When I checked with below it shows "jobs are not enabled"
BEGIN
IF APEX_PLSQL_JOB.JOBS_ARE_ENABLED THEN
HTP.P('Jobs are enabled on this database instance.');
ELSE
HTP.P('Jobs are not enabled on this database instance.');
END IF;
END;
I searched the forum but was not able to find solution for enabling jobs thru APEX. Have I do do anything different in 11g for enabling jobs.
How to enable jobs to be sent from the page. Pls HELP.