DBA_JOBS not getting executed. [message #233782] |
Fri, 27 April 2007 08:06 |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Hi,
Hi have a problem with my dba_jobs.
They have worked for at least a year now, but now they aren't being executed.
The job_queue_processes parameter is on 10.
SQL> SELECT NAME, value FROM v$parameter WHERE NAME LIKE '%job%';
NAME VALUE
--------- ---------
job_queue_processes 10
When I manually create a job, it shows up under dba_jobs, but is not executed.
SQL> DECLARE
2 v_id NUMBER;
3 v_job_what VARCHAR2(400);
4 BEGIN
5 v_job_what := 'begin dbms_output.put_line (''YO''); end;';
6 Dbms_Job.submit(job => v_id, what => v_job_what, next_date => SYSDATE,
INTERVAL => NULL);
7 END;
8 /
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> SELECT job, what FROM dba_jobs WHERE last_date IS NULL;
JOB WHAT
---------- ---------------------------
2355 begin dbms_output.put_line ('YO'); end;
If I manually start it, it's processed.
SQL> exec dbms_job.run(2355);
PL/SQL procedure successfully completed.
SQL> SELECT job, what FROM dba_jobs WHERE last_date IS NULL;
no rows selected
SQL>
Any Idea where the problem could be? I haven't found anything in the alert log or the dump directory.
Any way to check if the queue processes are indeed running process-wise on the Server maybe? My google-foo seems to be weak in that direction.
Oracle Version :
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Server OS : AIX 5.3
|
|
|
|
|
Re: DBA_JOBS not getting executed. [message #233896 is a reply to message #233801] |
Sat, 28 April 2007 00:28 |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
For the benefit of future forum searches :
It works again after the DB restart tonight.
It seems Metalink notes 102885.1 and 1026586.6 were right. They said basically :
"If you have checked job_queue_processes and the process on OS level, and it's still not working, then something really funny is going on with the job queue and you should restart the database"
|
|
|
|