Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Session purge jobs

partlycloudyOct 26 2010 — edited Oct 27 2010
A recent upgrade from 3.1.2 to 4.0.1 went fine but the 2 database jobs that purge old sessions and push the email queue are still pointing to the 3.1 version.

I followed Jason's instructions in 3318588 but it didn't quite work. Logging in as FLOWS_030100 was required to successfully execute the dbms_job.remove step so the jobs are now gone.

But running
apex_040000.wwv_flow_upgrade.create_jobs('APEX_040000')
as both SYS and APEX_040000 says 'PL/SQL procedure successfully completed.' but the jobs are not created.

Help? Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 24 2010
Added on Oct 26 2010
5 comments
584 views