Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help:dbms_job

Help:dbms_job

From: Nilufer <nilbas_at_ucdavis.edu>
Date: Mon, 01 Mar 1999 10:21:46 -0800
Message-ID: <36DADABA.ACF7CE52@ucdavis.edu>

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.

Nilufer
Email:nilbas_at_ucadvsi.edu Received on Mon Mar 01 1999 - 12:21:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US