OraFAQ Forum: SQL & PL/SQL » dbms

Home » SQL & PL/SQL » SQL & PL/SQL » dbms_job package problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbms_job package problem [message #40936]

Thu, 14 November 2002 01:13

Gurdeep Singh
Messages: 64
Registered: October 2002

Member

declare
l_job number;
begin
dbms_job.submit(l_job,'abc;',trunc(sysdate)+4/24,'trucn(sysdate)+1+4/24');
end;
above code is sucessfully compiled, but it it does't execute at 4am
where abc is procedre name
please tell me what's my fault

Report message to a moderator

Re: dbms_job package problem [message #40946 is a reply to message #40936]

Thu, 14 November 2002 04:25

B
Messages: 327
Registered: August 1999

Senior Member

Did U set
job_queue_processes
job_queue_interval

in ur init.ora ?

Report message to a moderator

Re: dbms_job package problem [message #40964 is a reply to message #40936]

Thu, 14 November 2002 11:38

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

If you actually submitted the interval as:

'trucn(sysdate)+1+4/24'

than that typo is a problem.

Report message to a moderator

Re: dbms_job package problem [message #40968 is a reply to message #40964]

Thu, 14 November 2002 20:53

Gurdeep Singh
Messages: 64
Registered: October 2002

Member

then tell me correct solution

Report message to a moderator

Re: dbms_job package problem [message #40980 is a reply to message #40964]

Fri, 15 November 2002 04:12

B
Messages: 327
Registered: August 1999

Senior Member

todd just tell U that

trucn doesn't exist .. it's TRUNC

be sure U set the init.ora parameter ( see my previous post )

Report message to a moderator

Re: dbms_job package problem [message #40994 is a reply to message #40936]

Fri, 15 November 2002 08:27

F. Tollenaar
Messages: 64
Registered: November 2002

Member

Did you commit the submission:

declare
  l_job number;
begin
  dbms_job.submit(l_job,'abc;',trunc(sysdate)+4/24,'trunc(sysdate)+1+4/24');
end;
/
<b>commit;</b>

Report message to a moderator

Previous Topic:	URGENT: PL/SQL TABLE
Next Topic:	sql prob

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 06 22:09:27 CDT 2024