Re: Help:dbms_job

It looks like Oracle doesn't understand what 'cron;' is. This has to be something you can call from the SQL> prompt, e.g.

dbms_job.submit(

    :jobno,
    'dbms_utility.analyze_schema( ''SCOTT'',''COMPUTE'');',     sysdate,
    'sysdate+1'
);

Hope that helps

Graham

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 Mon Mar 15 1999 - 14:44:40 CST