Re: Jobno in dbms_job.submit

From: Md Irfan <irfan_pk_at_hotmail.com>
Date: 25 Jun 2002 02:31:02 -0700
Message-ID: <c42168e7.0206250131.7427e4bb@posting.google.com>

"Jeremy Ovenden" <newsposter_at_hazelweb.co.uk> wrote in message >
> DECLARE
> j NUMBER;
> BEGIN
>
> dbms_job.submit(j,'wd_ctx_utils.sweep;',interval=>'sysdate+1/720
> ');
> dbms_output.put_line('Job# is '||j);
> END;
> /

---

Hi Jeremy
I get the following error, the job is I would like to run every day (or in the next day daily) at morning 3 AM.

SQL> variable jobno number;
SQL> begin
  2 dbms_job.submit(:jobno, 'UPDINVDTW;', trunc(sysdate+1),   3 trunc(sysdate+1+3/24));
  4 commit;
  5 end;
  6 /
begin
*
ERROR at line 1:

ORA-23319: parameter value "26-JUN-02" is not appropriate
ORA-06512: at "SYS.DBMS_JOB", line 49
ORA-06512: at "SYS.DBMS_JOB", line 119
ORA-06512: at line 2

I also checked this Connor's solution, but didn't worked

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&th=cbead3b73506570d&rnum=3

Thanks... Received on Tue Jun 25 2002 - 04:31:02 CDT