Home » SQL & PL/SQL » SQL & PL/SQL » dbms_job not working
dbms_job not working [message #401379] Mon, 04 May 2009 06:56 Go to next message
wmgonzalbo
Messages: 98
Registered: November 2008
Member
Hi experts,

* is it just me, but my search for topics in this forums always returns zero results for search by entire message or by topic.. i swear...

Anyway, please help.. My job isn't working.. I've set it in advance, about 3 mins advance, and after that it should run every 2 mins.. but it isn't... I tried to execute my procedure manually and it works..

declare
  my_job number;
begin
  dbms_job.submit(my_job, 
    'PAR_PROC1;',
    to_date ('05-04-2009 19:48:00','MM-DD-YYYY HH24:MI:SS'),
	'sysdate+0.0013889');
end;
/



select job, what from user_jobs;

JOB WHAT
206 PAR_PROC1;



Please help...

Regards,

Wilbert
Re: dbms_job not working [message #401382 is a reply to message #401379] Mon, 04 May 2009 07:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You must commit in order for the job coordinator to see the job.

Use 2/(24*60) instead of 0.0013889 it is more understandable and correct.

Regards
Michel
Re: dbms_job not working [message #401414 is a reply to message #401382] Mon, 04 May 2009 19:03 Go to previous message
wmgonzalbo
Messages: 98
Registered: November 2008
Member
Big Thanks Michel Cadot! God bless!
Previous Topic: Read blob value
Next Topic: SQL Expression
Goto Forum:
  


Current Time: Sat Dec 10 20:24:58 CST 2016

Total time taken to generate the page: 0.21106 seconds