APEX

Hi people,

I've got problem with automated jobs that runs on our application:

ORACLE_APEX_DAILY_MAINTENANCE - SCHEDULED 4/15/2011 01:00:00 +02:00 +000000000 00:00:00.032000 4/16/2011 01:00:00 +02:00
ORACLE_APEX_MAIL_QUEUE - SCHEDULED 4/15/2011 23:15:00 +02:00 +000000000 00:00:00.015000 4/15/2011 23:20:00 +02:00
ORACLE_APEX_PURGE_SESSIONS - SCHEDULED 4/15/2011 23:00:12 +02:00 - 4/16/2011 00:00:12 +02:00
ORACLE_APEX_WS_NOTIFICATIONS - SCHEDULED 4/15/2011 23:00:00 +02:00 +000000000 00:00:00.016000 4/15/2011 23:30:00 +02:00

The trouble is that everything was working fine for months, and suddenly stopped working last friday (4/15/2011), like if they didn't start for some reason and then left stuck in time, endlessly waiting for their scheduled time.
I thought of altering their next_time attribute for some time in future (now + 5 minutes), but I don't know how to do it:
- don't see any options in apex administration console
- went to sqlplus (login as sys sysdba), viewing all the jobs:

SQL> select
2 owner,
3 job_name,
4 job_class,
5 enabled,
6 next_run_date,
7 repeat_interval
8 from
9 dba_scheduler_jobs;

OWNER JOB_NAME
------------------------------ ------------------------------
JOB_CLASS ENABL
------------------------------ -----
NEXT_RUN_DATE
---------------------------------------------------------------------------
REPEAT_INTERVAL
--------------------------------------------------------------------------------

SYS PURGE_LOG
DEFAULT_JOB_CLASS TRUE
16.04.11 03:00:00.000000 US/PACIFIC



OWNER JOB_NAME
------------------------------ ------------------------------
JOB_CLASS ENABL
------------------------------ -----
NEXT_RUN_DATE
---------------------------------------------------------------------------
REPEAT_INTERVAL
--------------------------------------------------------------------------------

SYS FGR$AUTOPURGE_JOB
DEFAULT_JOB_CLASS FALSE

freq=daily;byhour=0;byminute=0;bysecond=0


OWNER JOB_NAME
------------------------------ ------------------------------
JOB_CLASS ENABL
------------------------------ -----
NEXT_RUN_DATE
---------------------------------------------------------------------------
REPEAT_INTERVAL
--------------------------------------------------------------------------------

SYS GATHER_STATS_JOB
AUTO_TASKS_JOB_CLASS TRUE




OWNER JOB_NAME
------------------------------ ------------------------------
JOB_CLASS ENABL
------------------------------ -----
NEXT_RUN_DATE
---------------------------------------------------------------------------
REPEAT_INTERVAL
--------------------------------------------------------------------------------

SYS AUTO_SPACE_ADVISOR_JOB
AUTO_TASKS_JOB_CLASS FALSE




OWNER JOB_NAME
------------------------------ ------------------------------
JOB_CLASS ENABL
------------------------------ -----
NEXT_RUN_DATE
---------------------------------------------------------------------------
REPEAT_INTERVAL
--------------------------------------------------------------------------------

APEX_040000 ORACLE_APEX_PURGE_SESSIONS
DEFAULT_JOB_CLASS TRUE
16.04.11 00:00:12.000000 +02:00
FREQ=HOURLY;BYMINUTE=0


OWNER JOB_NAME
------------------------------ ------------------------------
JOB_CLASS ENABL
------------------------------ -----
NEXT_RUN_DATE
---------------------------------------------------------------------------
REPEAT_INTERVAL
--------------------------------------------------------------------------------

APEX_040000 ORACLE_APEX_MAIL_QUEUE
DEFAULT_JOB_CLASS TRUE
15.04.11 23:20:00.000000 +02:00
FREQ=MINUTELY;BYMINUTE=0,5,10,15,20,25,30,35,40,45,50,55;BYSECOND=0


OWNER JOB_NAME
------------------------------ ------------------------------
JOB_CLASS ENABL
------------------------------ -----
NEXT_RUN_DATE
---------------------------------------------------------------------------
REPEAT_INTERVAL
--------------------------------------------------------------------------------

APEX_040000 ORACLE_APEX_WS_NOTIFICATIONS
DEFAULT_JOB_CLASS TRUE
15.04.11 23:30:00.000000 +02:00
FREQ=MINUTELY;BYMINUTE=0,30;BYSECOND=0


OWNER JOB_NAME
------------------------------ ------------------------------
JOB_CLASS ENABL
------------------------------ -----
NEXT_RUN_DATE
---------------------------------------------------------------------------
REPEAT_INTERVAL
--------------------------------------------------------------------------------

APEX_040000 ORACLE_APEX_DAILY_MAINTENANCE
DEFAULT_JOB_CLASS TRUE
16.04.11 01:00:00.000000 +02:00
FREQ=DAILY;BYHOUR=1;BYMINUTE=0;BYSECOND=0


OWNER JOB_NAME
------------------------------ ------------------------------
JOB_CLASS ENABL
------------------------------ -----
NEXT_RUN_DATE
---------------------------------------------------------------------------
REPEAT_INTERVAL
--------------------------------------------------------------------------------

ASPNET_DB_USER REMOVEEXPIRED_ASPNET_SESSITEMS
DEFAULT_JOB_CLASS TRUE
15.04.11 22:16:07.000000 +01:00
FREQ = MINUTELY


9 rows selected.

but I cannot alter their attribute:

SQL> EXEC DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (job_name => 'ORACLE_APEX_
MAIL_QUEUE',argument_name => 'RUN_DATE', argument_value => '20.04.11 15:23:00.0
00000 +02:00');
BEGIN DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (job_name => 'ORACLE_APEX_MAIL
QUEUE',argumentname => 'RUN_DATE', argument_value => '20.04.11 15:23:00.00000
0 +02:00'); END;

*
ERROR at line 1:
ORA-27476: "SYS.ORACLE_APEX_MAIL_QUEUE" does not exist
ORA-06512: at "SYS.DBMS_ISCHED", line 207
ORA-06512: at "SYS.DBMS_SCHEDULER", line 602
ORA-06512: at line 1

so, I tried to logon to sqlplus as user APEX_040000, but it won't let me saying the user is locked.

Any help would be appreciated...

thank you,
Vjeko