Re: Help:dbms_job

Just being curious but why does the error message reference SYS.DBMS_IJOB (note the " I " ) as opposed to SYS.DBMS_JOB. Was that the exact message or a typing error by you?

If it is the exact error message, assuming that cron is pointing to a PL/SQL package cron (it has to be otherwise it WILL fail), check for any typing errors in it that makes references to dbms_ijob.

Mark

Nilufer wrote in message <36DADABA.ACF7CE52_at_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 Tue Mar 16 1999 - 03:30:41 CST