Home » SQL & PL/SQL » SQL & PL/SQL » dbms_job related problem
dbms_job related problem [message #216684] Mon, 29 January 2007 21:55 Go to next message
sajut
Messages: 69
Registered: January 2007
Member
Hi
Where can I see the logs / error messages about user jobs, which are not run at the scheduled time? I have few jobs which are scheduled as below, but not run. When they are run manually, they run (exec dbms_job.run(1) )

Pls help

<code>
1 saleupd; 2007012909:00:14 09:00:14 2007013004:00:00 04:00:00 0 N
2 purcupd; 2007012909:04:28 09:04:28 2007013004:10:00 04:10:00 0 N
3 recupd; 2007012909:07:57 09:07:57 2007013004:20:00 04:20:00 0 N
4 payupd; 2007012909:11:48 09:11:48 2007013004:30:00 04:30:00 0 N
5 expupd; 2007012909:14:48 09:14:48 2007013004:40:00 04:40:00 0 N
21 stvalupd; 2007012909:15:20 09:15:20 2007013004:42:00 04:42:00 0 N
22 os_age; 2007012909:17:08 09:17:08 2007013004:45:00 04:45:00 0 N
25 os_age_sup; 2007012909:18:26 09:18:26 2007013005:05:00 05:05:00 0 N
41 os_age_upd; 2007012910:18:40 10:18:40 2007013004:48:00 04:48:00 0 N
26 osage_sup_upd; 2007012910:18:51 10:18:51 2007013005:10:00 05:10:00 0 N
27 ch_profit; 2007012910:19:01 10:19:01 2007013005:15:00 05:15:00 0 N
</code>
Re: dbms_job related problem [message #216758 is a reply to message #216684] Tue, 30 January 2007 04:51 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check the alert log for any errors.
Re: dbms_job related problem [message #216831 is a reply to message #216758] Tue, 30 January 2007 11:43 Go to previous messageGo to next message
sajut
Messages: 69
Registered: January 2007
Member
alert log is not showing any job related errors
Re: dbms_job related problem [message #216834 is a reply to message #216684] Tue, 30 January 2007 11:53 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
SQL> show parameter job
-- post results back here
Re: dbms_job related problem [message #216836 is a reply to message #216684] Tue, 30 January 2007 11:54 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
run the following query and paste the results

SELECT NEXT_DATE,INTERVAL,BROKEN FROM DBA_JOBS
where job=???

where ??? is the job number of the job that is not running

Re: dbms_job related problem [message #216932 is a reply to message #216834] Tue, 30 January 2007 22:44 Go to previous messageGo to next message
sajut
Messages: 69
Registered: January 2007
Member
show parameter job;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 0
Re: dbms_job related problem [message #216933 is a reply to message #216836] Tue, 30 January 2007 22:51 Go to previous messageGo to next message
sajut
Messages: 69
Registered: January 2007
Member
<code>
JOB NEXT_DATE INTERVAL BROKEN
---------- ---------------- ---------------------------------------- ----------
1 2007020104:00:00 trunc(sysdate)+1+(04/24)+(00/24/60) N
2 2007020104:10:00 trunc(sysdate)+1+(04/24)+(10/24/60) N
3 2007020104:20:00 trunc(sysdate)+1+(04/24)+(20/24/60) N
4 2007020104:30:00 trunc(sysdate)+1+(04/24)+(30/24/60) N
5 2007020104:40:00 trunc(sysdate)+1+(04/24)+(40/24/60) N
21 2007020104:42:00 trunc(sysdate)+1+(04/24)+(42/24/60) N
22 2007020104:45:00 trunc(sysdate)+1+(04/24)+(45/24/60) N
25 2007020105:05:00 trunc(sysdate)+1+(05/24)+(05/24/60) N
41 2007020104:48:00 trunc(sysdate+1)+4/24+48/60/24 N
26 2007020105:10:00 trunc(sysdate)+1+(05/24)+(10/24/60) N
27 2007020105:15:00 trunc(sysdate)+1+(05/24)+(15/24/60) N
</code>
Re: dbms_job related problem [message #217006 is a reply to message #216932] Wed, 31 January 2007 05:11 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You need to set job_queue_processes to a non-zero value (ie. 20).
Re: dbms_job related problem [message #217168 is a reply to message #217006] Wed, 31 January 2007 22:13 Go to previous message
sajut
Messages: 69
Registered: January 2007
Member
I changed the job_queue_processes=20 and it is working now.
Thank a log
Previous Topic: Calculating intervals in Milliseconds
Next Topic: Simple FULL OUTER JOIN but yet to be doing the JOIN desired
Goto Forum:
  


Current Time: Thu Dec 08 16:07:25 CST 2016

Total time taken to generate the page: 0.10868 seconds