I guess that this will not work. The "what" parameter (#2) must be the
name of a PL/SQL procedure, not the name of a script file! Maybe you can
run your script with Intelligent Agent but definitely not by
DBMS_JOB.SUBMIT!
Martin
Frederic Bidon wrote:
>
> Hi Zbeth,
> It seems that they're some missing parts in your understanding of PL/SQL.
> But the best way to learn is to try, and try again.
> Try this, I always do it like that (in an anonymous PL/SQL block) :
>
> DECLARE
> job INTEGER;
> no_parse BOOLEAN:=TRUE;
> BEGIN
> DBMS_JOB.SUBMIT
> (job,
> 'E:\ORANT\RDBMS\BACKUP\LXODBACKUP.SQL',
> sysdate,
> 'SYSDATE+1',
> no_parse)
> END;
> / (/ in SQL*PLus of course)
>
> For other PL/SQL questions, purchase the excellent Oracle PL/SQL
> programming from Oracle Press by Scott Urman, and visit www.revealnet.com
> where there is a PL/SQL pileline chat and some other good advices from Steve
> Feuerstein, a PL/SQL guru.
>
> Frederic.
>
> -----Original Message-----
> From: elee3_at_hotmail.com [mailto:elee3_at_hotmail.com]
> Sent: 20. januar 2000 22:51
> To: comp.databases.oracle.server_at_list.deja.com
> Subject: easy rdbms_job.submit question
>
> Message from the Deja.com forum:
> comp.databases.oracle.server
> Your subscription is set to individual email delivery
>
> This is a backup script job. What is wrong with this syntax?
>
> PROCEDURE DBMS_JOB.SUBMIT
> (job OUT BINARY_INTEGER,
> 'E:\ORANT\RDBMS\BACKUP\LXODBACKUP.SQL' IN VARCHAR2,
> sysdate,
> 1,
> no_parse)
>
> Thanks,
> Elizabeth
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
> _____________________________________________________________
> Deja.com: Before you buy.
> http://www.deja.com/
> * To modify or remove your subscription, go to
> http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.server
> * Read this thread at
> http://www.deja.com/thread/%3C867vv3%24or9%241%40nnrp1.deja.com%3E
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jan 26 2000 - 05:58:16 CST
