Re: Help:dbms_job

Nilufer schrieb:
>
> I am trying to setup a cron job in Oracle.
> execute dbms_job.submit(:jobno,'cron;',sysdate,'sysdate+1');
>
> I got this error message regarding to SYS.DBMS_IJOB and this package is
> already existed.
>
> at line 1:
> 4068: existing state of packages has been discarded
> 4067: not executed, package body "SYS.DBMS_IJOB" does not exist
> 6508: PL/SQL: could not find program unit being called
> 6512: at "SYS.DBMS_JOB", line 121
> 6512: at line 1
>
> Any help would be appreciated.
>

You've been granted the right to execute the package?

HTH
Matthias
--
grema_at_t-online.de

Es gibt nichts Neues mehr.
Alles, was man erfinden kann, ist schon erfunden worden. Charles H. Duell, Leiter des US Patentamtes bei seinem Rücktritt 1899 Received on Tue Mar 02 1999 - 01:36:17 CST